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 <robertmhaas@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