Andres Freund <and...@2ndquadrant.com> writes: > On 2014-08-30 13:50:40 -0400, Tom Lane wrote: >> A possible compromise is to sort a limited number of >> buffers ---- say, collect a few thousand dirty buffers then sort, dump and >> fsync them, repeat as needed.
> Yea, that's what I suggested nearby. But I don't really like it, because > it robs us of the the chance to fsync() a relfilenode immediately after > having synced all its buffers. Uh, how so exactly? You could still do that. Yeah, you might fsync a rel once per sort-group and not just once per checkpoint, but it's not clear that that's a loss as long as the group size isn't tiny. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers