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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
