Noah Freire wrote:
On Wed, Oct 29, 2008 at 4:46 PM, Matthew T. O'Connor <matthew@xxxxxxxx <mailto:matthew@xxxxxxxx>> wrote:Is the table being excluded? (see the pg_autovacuum system table settings)there's an entry for this table on pg_autovacuum, and it's enabled.Are you sure that it's not getting processed? Perhaps one worker is / has been churning on this table for a *LONG* time (that is afairly big table). Right. I was wrong :-) the table is being processed by autovacuum (I checked via pg_stat_activity). However, as you pinpointed, it's already running for hours (the test workload ended hours ago, basically it is just this autovacuum worker running on the system). Is there a way to make a more aggressive autovacuum setting for this table? it does not matter if it will affect performance, my concern is that it finishes as soon as possible. I wonder if a manual vacuum wouldn't be faster.
Yes, in the pg_autovacuum table, you can set per-relation vacuum cost delay settings etc...
-- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
