Re: new autovacuum criterion for visible pages - Mailing list pgsql-hackers

From Amit Kapila
Subject Re: new autovacuum criterion for visible pages
Date
Msg-id CAA4eK1LNwJAa_anCkk9jXPXPk+u3fPCz6tw2yqcvrAoC30xB8g@mail.gmail.com
Whole thread Raw
In response to new autovacuum criterion for visible pages  (Jeff Janes <jeff.janes@gmail.com>)
Responses Re: new autovacuum criterion for visible pages  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-hackers
On Thu, Aug 11, 2016 at 2:09 AM, Jeff Janes <jeff.janes@gmail.com> wrote:
> I wanted to create a new relopt named something like
> autovacuum_vacuum_pagevisible_factor which would cause autovacuum to
> vacuum a table once less than a certain fraction of the relation's
> pages are marked allvisible.
>

Why would it more convenient for a user to set such a parameter as
compare to existing parameters (autovacuum_vacuum_threshold +
autovacuum_vacuum_scale_factor)?

-- 
With Regards,
Amit Kapila.
EnterpriseDB: http://www.enterprisedb.com



pgsql-hackers by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: 9.6 phrase search distance specification
Next
From: Peter Eisentraut
Date:
Subject: Re: improved DefElem list processing