On Tue, Mar 16, 2010 at 2:30 PM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > "Pierre C" <lists@xxxxxxxxxx> writes: >> Does PG issue checkpoint writes in "sorted" order ? > > No. IIRC, a patch for that was submitted, and rejected because no > significant performance improvement could be demonstrated. We don't > have enough information about the actual on-disk layout to be very > intelligent about this, so it's better to just issue the writes and > let the OS sort them. Keep in mind that postgres is issuing writes to the OS buffer cache. It defers fsyncing the files as late as it can in the hopes that most of those buffers will be written out by the OS before then. That gives the OS a long time window in which to flush them out in whatever order and whatever schedule is most convenient. If the OS filesystem buffer cache is really small then that might not work so well. It might be worth rerunning those benchmarks on a machine with shared buffers taking up all of RAM. -- greg -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
