Re: Are all unlogged tables in any case truncated after a server-crash?

[Michael Lewis]

Curious... why keep the table as unlogged if it is static? If you can spare
the disk space, perhaps just create a regular table with same definition,
gradually copy the data to spread the impact on WAL, and when complete,
just drop the old table and rename the new one.