set autovacuum=off

Поиск
Список
Период
Сортировка
От Alessandro Gagliardi
Тема set autovacuum=off
Дата
Msg-id CAAB3BBLsZ94tTzaiTZrdpK+2m1waj8=VL31aPvOGFJ7oAGCHiQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: set autovacuum=off  (Thom Brown <thom@linux.com>)
Список pgsql-performance
I have a database where I virtually never delete and almost never do updates. (The updates might change in the future but for now it's okay to assume they never happen.) As such, it seems like it might be worth it to set autovacuum=off or at least make it so vacuuming hardly ever occurs. Actually, the latter is probably the more robust solution, though I don't know how to do that (hence me writing this list). I did try turning autovacuum off but got:

ERROR: parameter "autovacuum" cannot be changed now
SQL state: 55P02 

Not sure what, if anything, I can do about that. 

Thanks,
-Alessandro

В списке pgsql-performance по дате отправления:

Предыдущее
От: Venkat Balaji
Дата:
Сообщение: : Cost calculation for EXPLAIN output
Следующее
От: Thom Brown
Дата:
Сообщение: Re: set autovacuum=off