A very useful feature for unlogged tables would be the ability to switch them back to normal tables -- this way you could do bulk loading into an unlogged table and then turn it into a regular table using just fsync(), bypassing all the WAL-logging overhead. It seems this could even be implemented in pg_restore itself.
Which brings me to: On Tue, Dec 7, 2010 at 20:44, Robert Haas <robertmh...@gmail.com> wrote: > 2. Any crash truncates the table, but a clean shutdown does not. Seems that syncing on a clean shutdown could use the same infrastructure as the above functionality. Have you thought about switching unlogged tables back to logged? Are there any significant obstacles? Regards, Marti -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers