ruw1090

5 ms·

1.
by ruw1090 1y ago
No tax on tips does not apply to payroll taxes (FICA).
2.
by ruw1090 2y ago
The Xenomorph term wasn't created by the fandom. It was first used in-universe in "Aliens".
3.
by ruw1090 2y ago
Citation?
4.
by ruw1090 4y ago
Sure, but given multiple opportunities (every time the clip gets brought up) to condemn it, he hasn’t. This should tell you enough.
5.
by ruw1090 4y ago
Close, but in database years it was actually already in its mid life crisis.
6.
by ruw1090 4y ago
The snowflake clusters are several factors bigger (and more expensive) than almost all of the comparison points.
7.
by ruw1090 4y ago
That makes sense, thanks for clarifying. I got confused by the UI.
8.
by ruw1090 4y ago
Do you have any benchmark results with Clickhouse in a clustered configuration (and other db's)? Is Clickhouse expected to be run in only single node deployments?
9.
by ruw1090 4y ago
Yea, Redshift looks like it was run on an ra3.xl (4 cores) and is comparing against clickhouse on a c6a.4xl (16 cores). I suspect if this were normalized Redshift would have an edge.
10.
by ruw1090 4y ago
There's a lot more involved in an execution engine running complex queries that are not single table group by than just QO (though this is important). It includes things like join implementations and associated optimizations, shuffle p
11.
by ruw1090 4y ago
The total estimated cost has increased by 44 Billion. Only ~10 billion has been spent on the project so far.
12.
by ruw1090 4y ago
I stopped reading at "Incredibly, the state has not laid a single mile of track" for California High Speed rail, which is completely false. There are 119 miles under active construction and they've been putting down track sin
13.
by ruw1090 7y ago
> You are correct however that TimescaleDB requires more storage than some of these other options. If storage is the most important criteria for you (ie more important than usability or performance), then again I would recommend you to o
14.
by ruw1090 8y ago
To build on the list of features above, here's a blog post from Pandora where they go into the details of what they use MemSQL for and some of the alternatives they looked into for their use case: https://engineering.pandora
15.
by ruw1090 8y ago
I mean that an operation that needs more memory than is available will fail, but the server itself will remain operational. An simple example would be loading more data into an in-memory table (row store) than there is available memory. If
16.
by ruw1090 8y ago
If you have an example of the query you thought was returning inconsistent results, feel free to make a post over at https://www.memsql.com/forum/ with a repro.
17.
by ruw1090 8y ago
The best thing to do in this situation would be to set the maximum memory on the MemSQL server via the `maximum_memory` system variable. The server will then internally manage it's memory usage against this upper bound and fail only sp
18.
by ruw1090 8y ago
> data allowance of 10 million rows, and range up to a 100 million row allowance. Only supporting up to 100 million rows seems extremely limiting for a lot of analytics use cases. What's the reasoning behind this? Does the product
19.
by ruw1090 9y ago
The other thing that is misleading about this benchmark is that the comparison page shows results for many different DBs on vastly different hardware without any mention of price. It would be much more valuable if it attempted to normalize
20.
by ruw1090 9y ago
What is the benefit of shipping data to the GPU for execution if the data is on S3 or HDFS? Won't most of the cost of the query be I/O?
21.
by ruw1090 9y ago
It looks like you had to rewrite the queries pretty significantly to get them to run on all three. Redshit/Bigquery don't support rollup/grouping sets/intersect/except etc. which the TPCDS spec queries have. Is ther
22.
by ruw1090 9y ago
So blazing db mainly uses gpus to speed up compression/decompression? How do gpus help with partitioning and data skipping?
23.
by ruw1090 10y ago
citation?
24.
by ruw1090 10y ago
very interesting. Do you have a link to documentation? I'd like to take a look before I try it out.
25.
by ruw1090 10y ago
It looks like they benchmarked against MemSQL 3.2, which is nearly 2 years old and Hive .11, which is close to 3 years. Not sure how out of date the other comparisons are.
26.
by ruw1090 10y ago
While I love to hate on MongoDB as much as the next guy, this behavior is consistent with read-committed isolation. You'd have to be using Serializable isolation in an RDBMS to avoid this anomaly.
27.
by ruw1090 11y ago
It's actually quite common throughout the world for railroads to have their own police force. http://en.wikipedia.org/wiki/Railroad_police