* Tatsuo Ishii (ishii@postgresql.org) wrote:
> Yeah, at first I thought using WAL was a good idea. However I realized
> that the problem using WAL is we cannot backup unlogged tables because
> they are not written to WAL.
Unlogged tables are also nuked on recovery, so I'm not sure why you
think an incremental backup would help.. If you're recovering (even
from a simple crash), unlogged tables are going to go away.
Put simply, unlogged tables should not be used for any data you care
about, period.
Thanks,
Stephen