jaime soler wrote on 14.03.2015 12:30:
>> What if you change that big table to UNLOGGED?
>> As unlogged tables don't generate WAL they don't contribute to the PITR "restore time"
>> (and they won't be restored if you have to do a PITR!)
>
> However, they are not crash-safe: an unlogged table is automatically
> truncated after a crash or unclean shutdown.
That is correct, but Martin wrote in the initial question:
> The backup of the table itself is also reduntant,
>as the table data can be recreated by importing from the source files
So if the data lost, it apparently doesn't matter.
