Re: Should we increase the default vacuum_cost_limit? - Mailing list pgsql-hackers

From Robert Haas
Subject Re: Should we increase the default vacuum_cost_limit?
Date
Msg-id CA+Tgmoas1AbDQPAoE1yE9U7d56j06swZvickKKfoYjUoM3t6UQ@mail.gmail.com
Whole thread Raw
In response to Re: Should we increase the default vacuum_cost_limit?  (David Rowley <david.rowley@2ndquadrant.com>)
Responses Re: Should we increase the default vacuum_cost_limit?
Re: Should we increase the default vacuum_cost_limit?
List pgsql-hackers
On Mon, Feb 25, 2019 at 8:39 AM David Rowley
<david.rowley@2ndquadrant.com> wrote:
> I decided to do the times by 10 option that I had mentioned.... Ensue
> debate about that...

+1 for raising the default substantially.  In my experience, and it
seems others are in a similar place, nobody ever gets into trouble
because the default is too high, but sometimes people get in trouble
because the default is too low.  If we raise it enough that a few
people have to reduce it and a few people have to further increase it,
IMHO that would be about right.  Not sure exactly what value would
accomplish that goal.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Remove Deprecated Exclusive Backup Mode
Next
From: Stephen Frost
Date:
Subject: Re: Remove Deprecated Exclusive Backup Mode