On Mon, Sep 10, 2012 at 5:30 PM, David Morton <davidmorton78(at)gmail(dot)com>wrote:
> We have many large tables which contain static historical data, they are
> auto vacuumed on a regular basis (sometimes to prevent wraparound) which i
> suspect causes a few annoying side effects:
> - Additional WAL file generation
> - Increased 'changed' data as far as our online rsync based backups are
> concerned
>
> Is there any way to tell Postgres that these tables are now not available
> for changes so we can avoid these seemingly pointless maintenance tasks ?
>
ALTER TABLE *table_name* SET (
autovacuum_enabled = false
);