Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

PostgreSQL Scalability: Towards Millions TPS

akorotkov.github.io

Post reply on HN
Print view View original

61–70 of 222 posts

Re: PostgreSQL Scalability: Towards Millions TPS

#61

Post by anarazel »

Ono-Sendai wrote: post #51
anarazel wrote: post #46

Earlier quoted context omitted.

> Would it be possible to dynamically choose the padding at server start time? I doubt it. Allowing the compiler to generate accesses with lea et al. is quite beneficial; and that'd likely be gone by making this not be a compile time constant. It'd also end up being a tuning knob very very few knew how to tune... > Given that cache line sizes vary that seems like it might be a prudent choice. They usually only vary b…

cache line size is 64 B on recent intel CPUs.

That's why I said that we'd use a smaller cache-line size for most architectures. PPC uses 128byte tho..

Re: PostgreSQL Scalability: Towards Millions TPS

#63

Post by zAy0LfpBZLC8mAC »

fbernier wrote: post #14
jrcii wrote: post #12

Slightly tangential but I'm genuinely curious, does any have a theory as to why nearly every RDBMS post on Hacker News is about Postgres and almost never MySQL or MariaDB? Considering the relative obscurity of the former it seems somewhat inexplicable.

I guess it depends on your own personal background, but PostgreSQL is far from 'obscure' and much more feature complete than MySQL nowadays.

Why "nowadays"? I can't really remember a time when it wasn't. If anything, MySQL is far less incomplete than it once was (like, it even supports transactions now, which once was one of the most important reasons for using Postgres over MySQL).

Re: PostgreSQL Scalability: Towards Millions TPS

#64

Post by morgo »

jrcii wrote: post #12

Slightly tangential but I'm genuinely curious, does any have a theory as to why nearly every RDBMS post on Hacker News is about Postgres and almost never MySQL or MariaDB? Considering the relative obscurity of the former it seems somewhat inexplicable.

lots of things happening in the MySQL world:

- a couple of weeks ago we released a document store (new protocol + connectors) based on protobufs

- last year 5.7 was released. Many new features, I have a list here: http://www.thecompletelistoffeatures.com

Re: PostgreSQL Scalability: Towards Millions TPS

#65

Post by nickpsecurity »

the-dude wrote: post #49
qaq wrote: post #43

Earlier quoted context omitted.

Reminds me of a talk by Bryan Cantrill he talked a bit (I am paraphrasing) that he didn't believe that people could be purely evil and when looking into Larry Ellisson he actually discovered he donated several hundred mil. to a nonprofit (dedicated to prolonging human life). On closer look it turned the sole purpose of that nonprofit was working on prolonging life of one particular human namely Larry Ellisson. (while…

One Rich Asshole Called Larry Ellison

I love it! Gotta try to remember that one!

Re: PostgreSQL Scalability: Towards Millions TPS

#66

Post by morgo »

cwbrandsma wrote: post #29
jrcii wrote: post #12

Slightly tangential but I'm genuinely curious, does any have a theory as to why nearly every RDBMS post on Hacker News is about Postgres and almost never MySQL or MariaDB? Considering the relative obscurity of the former it seems somewhat inexplicable.

MySQL is considered more "old school" and not great at being standards compliant when installed with default settings. See https://twitter.com/robconery/status/189086889486192640 Also, MySQL is run by Oracle...and Oracle a horrible company run by horrible people that behave horribly, and should never ever be trusted in any form. Any developer relying or Oracle code should not be trusted ever again, and Oracle consult…

What you are describing is no longer the default configuration.

Say what you like about oracle, they have been a great steward of MySQL.

Re: PostgreSQL Scalability: Towards Millions TPS

#67

Post by morgo »

twic wrote: post #50
jrcii wrote: post #12

Slightly tangential but I'm genuinely curious, does any have a theory as to why nearly every RDBMS post on Hacker News is about Postgres and almost never MySQL or MariaDB? Considering the relative obscurity of the former it seems somewhat inexplicable.

Are the MySQL or MariaDB communities publishing interesting stuff like this? That's a genuine question - i'm no longer a MySQL user, so i don't pay any attention to what's going on myself.

Yes. Mysqlserverteam.com links usually do not show up on HN, but we have similar benchmarks showing RO throughout to 1.6m qps on Intel

Re: PostgreSQL Scalability: Towards Millions TPS

#70

Post by ryanobjc »

jlgaddis wrote: post #37
cwbrandsma wrote: post #29

Earlier quoted context omitted.

MySQL is considered more "old school" and not great at being standards compliant when installed with default settings. See https://twitter.com/robconery/status/189086889486192640 Also, MySQL is run by Oracle...and Oracle a horrible company run by horrible people that behave horribly, and should never ever be trusted in any form. Any developer relying or Oracle code should not be trusted ever again, and Oracle consult…

I am in no way a fan of Oracle but, c'mon, that's a little over the top, don't you think?

A silicon valley amateur radio club recently moved their study and test sessions from Oracle to Google, because Oracle changed their non-profit rate to $2000/day for a room. Google doesn't charge as long as a contact employee takes responsibility for the meeting.

So yeah, Oracle, evil to the core.

Post reply on HN