Re: auto vacuuming
| От | Matthew T. O'Connor |
|---|---|
| Тема | Re: auto vacuuming |
| Дата | |
| Msg-id | 442DBF22.6090303@zeut.net обсуждение исходный текст |
| Ответ на | Re: auto vacuuming ("Jim C. Nasby" <jnasby@pervasive.com>) |
| Ответы |
Re: auto vacuuming
|
| Список | pgsql-admin |
>> I think the closest approximation of disabling autovacuum on a per >> database basis is to connect to the database in question and perform: >> >> update pg_autovacuum set enabled = 'false'; >> >> This will prevent autovacuum from vacuuming or analyzing any of the >> tables in the database, but will still check for XID wraparound. >> > > Problem with that is any time you add a table you'd need to re-run that > command. Wouldn't be so bad if we had DDL triggers, but... > Probably a dumb comment, but can you set a default value for the enabled column?
В списке pgsql-admin по дате отправления: