Live data from Hacker News

CockroachDB 2.0 Performance Makes Significant Strides

cockroachlabs.com

41–50 of 187 posts

Re: CockroachDB 2.0 Performance Makes Significant Strides

#41
post #36

Earlier quoted context omitted.

You're not going to get better performance for OLAP than MemSQL's columnstore and in-memory rowstore for reference tables to join. Citus is great if you want the Postgres interface but is still using standard rowstore tables. CockroachDB is similar with rowstore performance but with added distributed consensus overhead. They are both much better for OLTP and sharding. CockroachDB also provides easy high-availability…

MemSQL is one of those "ask for a quote" products. What are some rule of thumb estimates for what it costs?

Licensed by total RAM of all nodes. $25k/year minimum license now, but you should still talk to them if you're a small company. Regardless of price, I highly recommend the product as one of the most polished data warehouses available for on-prem/self-managed operations.

Re: CockroachDB 2.0 Performance Makes Significant Strides

#43
post #31

Before clicking the comments link, I always know what to expect in HN comment section for a CDB post announcing their latest milestone or feature: A lot of congrats and excitement, questions about who uses it in a production environment, very specific use-case questions, and of course the name. Weird how predictable the response to one company/tech always is.

came here to comment on the name.

Re: CockroachDB 2.0 Performance Makes Significant Strides

#44

I will never use this product no matter how good it is due to its name. Hope you can understand that many ppl like me suffer phobia from cockroaches. (PS: As expected ppl will downvote this, but just trying to give a very valuable feedback to ppl who don’t understand cockroach phobia.)

It can also be called CRDB.

Re: CockroachDB 2.0 Performance Makes Significant Strides

#45

Earlier quoted context omitted.

Yes just hearing or reading the word “cockcroach” gives me a cringe. I tried to google the word “cockroach phobia” just now and damn google shows a bunch of cockroach images that made me press back button immediately and couldn’t read a damn thing. Im not sure what will happened to my job but given an equal choice i would choose alternatives, job or database.

Why don't you just write a browser script extension to edit out your trigger word? It might be easier than expecting a database company to change the name of what they make.

I like this idea, I wonder if other individuals with similar phobias would benefit from it. Wasn't there one, or perhaps multiple ones, to change variations of Trumps name at one point?

Re: CockroachDB 2.0 Performance Makes Significant Strides

#46
post #22

How is this meaningful without detailed setup description? http://www.tpc.org/tpcc/results/tpcc_results.asp?print=false... Looking at this list of results one wonders what those results actually mean?

At the bottom of the article it says that information is coming: "Note: We have not filed for official certification of our TPC-C results. However, we will post full reproduction steps in a forthcoming whitepaper."

I guess will have to wait. The progress they made is obviously impressive but would really help if one could understand the overhead vs conventional RDBMS 5X might be OK 20X not so much.

Re: CockroachDB 2.0 Performance Makes Significant Strides

#47

I will never use this product no matter how good it is due to its name. Hope you can understand that many ppl like me suffer phobia from cockroaches. (PS: As expected ppl will downvote this, but just trying to give a very valuable feedback to ppl who don’t understand cockroach phobia.)

Just so you know, it’s possible to overcome a phobia. In fact my startup Fearless helps people to just that, using VR. We have a module for cockroaches specifically. It goes very gradually, starting with a cartoon drawing, and progresses at your own pace. If you’re interested, http://FearlessVR.com

Also, I understand your complaint about the name, as I’ve encountered many, many people with all sorts of phobias at varying levels of extremity. It’s more common than most people think.

Re: CockroachDB 2.0 Performance Makes Significant Strides

#48

I will never use this product no matter how good it is due to its name. Hope you can understand that many ppl like me suffer phobia from cockroaches. (PS: As expected ppl will downvote this, but just trying to give a very valuable feedback to ppl who don’t understand cockroach phobia.)

[deleted]

Re: CockroachDB 2.0 Performance Makes Significant Strides

#49

Earlier quoted context omitted.

That's unfortunate, but I hope your post isn't suggesting they shouldn't have named their product as they did. Should people who don't like large numbers not use Google? Should people who fear fire not use Firebase? Should people who don't like coffee not use Java? Moreover, should those people suggest the names be changed due to their phobia? We could number all database servers. Server 1, Server 2, Server 3, Server…

Are there people or cultures who have a fondness for cockroaches?

Wall-E

Re: CockroachDB 2.0 Performance Makes Significant Strides

#50
post #17

How much and what kind of memory and storage (SATA SSD, NVMe SSD, HDD?) is included in the 3 nodes used for testing? This benchmarking is really interesting but the next level is to understand the cost per tmpC measured. Memory especially and storage is a big component of cost these days.

Short answer: 3 n1-highcpu-16 GCE VMs with Local SSDs attached. We're working on a complete disclosure document, with comprehensive reproduction steps to replicate all our numbers. This document should be out in a couple of weeks. We want to walk you through, command by command, on how to reproduce these numbers, and verify the results for yourself.
Post reply on HN