News for hackers. Stuff that matters.
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.
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. :)

Re:Dear Postgres by anarazel on Friday October 13, 2017 @04:32PM (#15469034)
I 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 :)