Table-level log_autovacuum_min_duration - Mailing list pgsql-hackers

From Michael Paquier
Subject Table-level log_autovacuum_min_duration
Date
Msg-id CAB7nPqQUsW+qfWFkYO6319BdGPHqU0nhRrSx4Sn-iPrhYPXnqg@mail.gmail.com
Whole thread Raw
Responses Re: Table-level log_autovacuum_min_duration  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-hackers
Hi all,

Today I spent a bit of time looking at the activity of autovacuum for
one table particularly bloated. log_autovacuum_min_duration was
enabled and set to a high value but even with that I had to deal with
some spam from the jobs of other tables. It would be cool to have the
possibility to do some filtering IMO. So, what about having a relopt
to control log_autovacuum_min_duration? RelationData->rd_options is
largely accessible for a given relation in the code paths of vacuum
and analyze.
Thoughts?
-- 
Michael



pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: WIP patch for Oid formatting in printf/elog strings
Next
From: Robert Haas
Date:
Subject: Re: exitArchiveRecovery woes