Cool new Free software
Posted Dec 20, 2012 15:15 UTC (Thu) by nix
In reply to: Cool new Free software
Parent article: Status.net service to phase out, replaced by pump.io
on my workstation from 2009, with other stuff going on, in an absolutely unoptimized configuration, PG does 320k readonly transactions per sec and 140k trivial writing ones.
How? With an absolutely unoptimized default configuration, each commit involves a sync, which involves waiting for the disk. There's no way you can do more than a few hundred such transactions per second unless you have a battery-backed RAID array so you don't need to wait for on-the-average half a disk rotation to bring the data under the head (and then possibly another avg half rotation for associated metadata). Doing 320,000 transactions per second with PostgreSQL is hard to imagine.
I am obviously missing something. (Again. It's not my week...)
to post comments)