Re: autovacuum_freeze_max_age on append-only tables
От
Senor
Тема
Re: autovacuum_freeze_max_age on append-only tables
Дата
Msg-id
DM8PR01MB7016C2C60B69B5BE1CAB3E8CF7F79@DM8PR01MB7016.prod.exchangelabs.com
Ответ на
Re: autovacuum_freeze_max_age on append-only tables (David G. Johnston)
Список
Дерево обсуждения
autovacuum_freeze_max_age on append-only tables senor <frio_cervesa@hotmail.com>
Re: autovacuum_freeze_max_age on append-only tables Laurenz Albe <laurenz.albe@cybertec.at>
Re: autovacuum_freeze_max_age on append-only tables Senor <frio_cervesa@hotmail.com>
Re: autovacuum_freeze_max_age on append-only tables Peter Geoghegan <pg@bowt.ie>
Re: autovacuum_freeze_max_age on append-only tables "David G. Johnston" <david.g.johnston@gmail.com>
Re: autovacuum_freeze_max_age on append-only tables Senor <frio_cervesa@hotmail.com>
Re: autovacuum_freeze_max_age on append-only tables Peter Geoghegan <pg@bowt.ie>
Thanks David
In any case the cost-based stuff throttles I/O only (per the docs at least) but even while sleeping it still holds its lock. And it won't be kicked off of the lock by other processes. I don't see where it is documented that the autovacuum cost settings are altered during the anti-wraparound vacuum so I presume it will still sleep by default.
I knew I was misunderstanding something. I had picked up the impression that the vacuum process cost_delay released the lock for the period. Not just do nothing. Seems like that would be worth mentioning in the Docs. I'm learning this from the inside out in the tradition of "well someone has to do it". I'm sure I'm not alone.
-Senor
В списке pgsql-general по дате отправления