>> Unlogged table can increase speed, this table has about 1.6
>> millions of update per hour, but unlogged with a chance of loss
>> all information on a crash are not a good idea for this.
>
> pg_dump -t 'tablename' from a cron job? (Make sure to rotate dump
> file names, maybe with day of week or some such.)
Or just "CREATE TABLE AS" copy the table every hour to a second, backup
table. Then it would be much easier to script automated restore of the
data.
--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com