The return of the auto-vacuum
От | Nestor A. Diaz |
---|---|
Тема | The return of the auto-vacuum |
Дата | |
Msg-id | 54DB79F3.9050202@tiendalinux.com обсуждение исходный текст |
Ответы |
Re: The return of the auto-vacuum
|
Список | pgsql-general |
Hello Everybody, This is the scenario: I have a postgres 8.4, debian packages installed from pgdg repository and version equal to: 8.4.21-1.pgdg70+1 I have a GPS database that insert about 4 million records on some tables every week, the database is partitioned per week, I do a manual vacuum every week and when we start the week then we 'vacuum analyze' the last week tables. However sometimes we have autovacuum running on older tables and I don't know why, something like this: autovacuum: VACUUM partitions.device_event_2015w05 (to prevent wraparound) Those tables are almost read only, they are just involved in select queries, but the system sometimes autovacuum them. Any guess on why is the autovacuum daemon starting the process on those tables ? It doesn't matter if they have been vacuumend before and nothing have changed on those tables ? Sorry, I still don't understand how the 'prevent wraparound' works, I thought that 'vacuum to prevent wraparound' only got fired on tables that were highly modified. Thanks. -- Nestor.
В списке pgsql-general по дате отправления: