Live data from Hacker News

PostgreSQL Scalability: Towards Millions TPS

akorotkov.github.io

221–222 of 222 posts

Re: PostgreSQL Scalability: Towards Millions TPS

#221
post #157

Earlier quoted context omitted.

I have been using it a lot lately, and do like it. It isn't a popular opinion on HN, but I will still advise for Oracle or SQL Server in terms of tooling, cluster scaling, server side programming and DB drivers. Then again, we work with customers whose Oracle and SQL Server licenses costs aren't an issue.

1) Coming to a discussion on Postgres and saying Oracle is better is clearing trolling 2) "server side programming" - as you have the source code with Postgresql and their a plugins for most major programming languages I don't buy this. 3) If you of spent the same on Enterprisedb or CitusDB I can guarantee you would get similar polish and support. People don't.

Can you explain how the comment was trolling? It seemed to be a legitimate comparison.

Re: PostgreSQL Scalability: Towards Millions TPS

#222
post #163

Postgres is still going through the motions of a transaction for every query you issue it even if nothing else but that transaction is happening on the server. So obviously if you add extra load in the form of writes, you may slow your reads down, but this was not a full benchmark, but instead a comparison of the same workload running against multiple versions of Postgres.

Huh, that's funny to see a comment of mine copied word for word from Reddit: https://www.reddit.com/r/programming/comments/4in70l/postgre...
Post reply on HN