Re: vacuum and autovacuum - is it good to configure the thresholdat TABLE LEVEL?

Поиск
Список
Период
Сортировка
От rajan
Тема Re: vacuum and autovacuum - is it good to configure the thresholdat TABLE LEVEL?
Дата
Msg-id 1543376490729-0.post@n3.nabble.com
обсуждение исходный текст
Ответ на Re: vacuum and autovacuum - is it good to configure the threshold atTABLE LEVEL?  (amul sul <sulamul@gmail.com>)
Ответы Re: vacuum and autovacuum - is it good to configure the threshold atTABLE LEVEL?  (amul sul <sulamul@gmail.com>)
Список pgsql-hackers
Thanks, amul. I have already gone through this. What I would like to
understand is the performance impact on autovacuum launcher and worker
process when autovacuum is running from configurations done by
*ALTER TABLE autvac_test SET (autovacuum_vacuum_scale_factor = 0,
autovacuum_vacuum_threshold = 100);*
 at table level.



-----
--
Thanks,
Rajan.
--
Sent from: http://www.postgresql-archive.org/PostgreSQL-hackers-f1928748.html


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

Предыдущее
От: Thomas Munro
Дата:
Сообщение: Re: "pg_ctl: the PID file ... is empty" at end of make check
Следующее
От: Kyotaro HORIGUCHI
Дата:
Сообщение: Re: Tab completion for ALTER INDEX|TABLE ALTER COLUMN SETSTATISTICS