turn auto vacuum off for those tables.
于 2012/9/11 4:30, David Morton 写道:
> 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 ?
>
> Dave