3 ms·
One point I found very interesting was the following paragraph: > For example, on my (pretty average) workstation, I can do ca. 25k simple read transactions pe
by fabian2k 6y ago
One point I found very interesting was the following paragraph:
> For example, on my (pretty average) workstation, I can do ca. 25k simple read transactions per 1 CPU core on an “in memory” pgbench dataset…with the default config for Postgres v13!
In my own very unscientific experiments I never got values as high as that, but in the area of around 4k transactions per second total on multiple cores. Of course I'm comparing very different things, I was looking at more than just the database and there are lots of other aspects I probably did in a different way.
I find this interesting as it probably means that my bottleneck wasn't entirely where I thought it was. I have to play around with that some time again.
If I wanted to find out the baseline Postgres performance on my hardware for trivial read queries like looking up individual rows by primary key with a database that fits entirely in RAM, how would I do that? I know there is pgbench, but that performs more complex queries as far as I understand.
- __s 6y agoYou can give pgbench files to have it run the query you want (see -f flag) https://www.postgresql.org/docs/current/pgbench.html https://www.postgresql.org/docs/current/pgbench.html
- ahachete 6y agoAs this is a public reference: GitLab's Postgres cluster handles peaks of 300K tps, where the master node alone supports around 60K-80K. And this is not in-memory (datasize in the order of 8TB, RAM 600GB). https://about.gitlab.com/blog/2020/09/11/gitlab-pg-upgrade/ https://about.gitlab.com/blog/2020/09/11/gitlab-pg-upgrade/ And there's still room for vertical scaling. Disclaimer: we provide Postgres support for GitLab.
- mmacedo_en 6y agoHN is missing an user follow and user tagging button :-)
- ahachete 6y agoIf that's for me, I really appreciate that :) There's obviously that option on Twitter (same username as here), if you want to follow there ;)
- mmacedo_en 6y agoDid it already :-) Good idea putting twitter link on your profile
- Shorn 6y agoI wish HN published the user comments/subscriptions pages as RSS. For example, I "follow" a few users on StackOverflow by adding the feed that SO makes available linked from their profile. Super useful.
- deleted 6y ago[deleted]