Re:Dear Postgres
by anarazel on Friday October 13, 2017 @04:07PM
(#15468867)
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.
[ Parent
| on HN ]
Re:Dear Postgres
by justinclift on Friday October 13, 2017 @04:14PM
(#15468900)
Those 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. :)