On Wed, Nov 17, 2010 at 3:11 PM, Tom Lane <[email protected]> wrote: > Heikki Linnakangas <[email protected]> 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
