4 ms·
I think that's not quite right. There's a lot of things besides default settings that lead to not so great performance. Before spread checkpoints, HOT, short va
by anarazel 9y ago
I think that's not quite right. There's a lot of things besides default settings that lead to not so great performance. Before spread checkpoints, HOT, short varlenas, readonly transactions not needing a txid, the free space map (remember max_fsm_pages), autovacuum, custom plans for prepared statements, asynchronous commits... it was a lot harder to use PG for higher throughput systems.
- justinclift 9y agoThose likely contributed, but the shared_buffers setting was the outright major culprit at the time. Go look back through the -hackers mailing list, probably ~2001-2002. Or maybe just look at the timestamps for when the default changed, in order to get the right time range. :)
- anarazel 9y agoI used postgres before and after all of these changes, and I used mysql at that time too... And before you accuse me of anti postgres bias: I work on postgres all day :)