On 2014-01-09 16:27:23 -0500, Robert Haas wrote: > People *think* they don't like that, because that's the way it works > right now. If it worked some other way, there's a good chance people > would be complaining about that behavior, too.
I think on of the primary reason why it's causing huge slowdowns is that the ring buffer of scan strategies causes dirty buffer writes pretty much immediately, when a buffer is reused. Not that delaying the writeout would work all that effectively right now, with the current bgwriter... Greetings, Andres Freund -- Andres Freund http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers