Live data from Hacker News

PostgreSQL Scalability: Towards Millions TPS

akorotkov.github.io

11–20 of 222 posts

Re: PostgreSQL Scalability: Towards Millions TPS

#11
post #3

I don't know much but to me it seems PostgreSQL is probably one of the most open and supporting communities maybe this is reason alot of new faces are looking at it including me.

It's also a great example of a technology which is mature and well-tested yet actively growing and improving. Most open source projects have a lot to learn from Postgres.

[deleted]

Re: PostgreSQL Scalability: Towards Millions TPS

#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.

Re: PostgreSQL Scalability: Towards Millions TPS

#13

     In partnership with IBM we researched PostgreSQL scalability on modern Power8 servers. 
That statement and the linked Russian blog white paper[1] makes it seem like a Power8 specific and Power8 is a "a massively multithreaded chip"[2]. I wonder how far off it would be to x86-64?

[1] https://habrahabr.ru/company/postgrespro/blog/270827/

[2] https://en.wikipedia.org/wiki/POWER8

Re: PostgreSQL Scalability: Towards Millions TPS

#14
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.

Re: PostgreSQL Scalability: Towards Millions TPS

#15
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.

It's because Python tends to be the most common programming language for startups due to being easy to hire for, having good library support for a wide range of use cases, being good for web development, etc. And MySQL is focused on catering to enterprise customers who don't use Python. The last time I heard, they had something like one person working part time on Python support, so the drivers weren't nearly as reliable as the Postgres tooling.

Re: PostgreSQL Scalability: Towards Millions TPS

#16
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.

Because.... people that use postgresql are ~usually better developers, they care more + post more + upvote more.

Re: PostgreSQL Scalability: Towards Millions TPS

#17
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.

Because.... people that use postgresql are ~usually better developers, they care more + post more + upvote more.

Do you have evidence that you can share?

Re: PostgreSQL Scalability: Towards Millions TPS

#19
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.

It's because Python tends to be the most common programming language for startups due to being easy to hire for, having good library support for a wide range of use cases, being good for web development, etc. And MySQL is focused on catering to enterprise customers who don't use Python. The last time I heard, they had something like one person working part time on Python support, so the drivers weren't nearly as reli…

Pretty sure there are more or at least as much startups using Ruby, JS, PHP, Java before Python.

Re: PostgreSQL Scalability: Towards Millions TPS

#20

Earlier quoted context omitted.

Because.... people that use postgresql are ~usually better developers, they care more + post more + upvote more.

Do you have evidence that you can share?

No. Just from all the devs that I've talked to, the ones that know more about rdbms prefer postgresql.
Post reply on HN