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.
--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
