On Wed, Nov 17, 2010 at 3:11 PM, Tom Lane <t...@sss.pgh.pa.us> wrote: > Heikki Linnakangas <heikki.linnakan...@enterprisedb.com> writes: >> fsync()ing the file at shutdown doesn't seem too bad to me from >> performance point of view, we tolerate that for all other tables. And >> you can always truncate the table yourself before shutdown. > > The objection to that was not about performance. It was about how > to find out what needs to be fsync'd. >
Just a crazy brainstorming thought, but.... If this is a clean shutdown then all the non-unlogged tables have been checkpointed so they should have no dirty pages in them anyways. So we could just fsync everything. -- greg -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers