Re: Fixed xloginsert_locks for 9.4 - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Fixed xloginsert_locks for 9.4
Date
Msg-id 20141003180745.GF14522@momjian.us
Whole thread Raw
In response to Re: Fixed xloginsert_locks for 9.4  (Arthur Silva <arthurprs@gmail.com>)
Responses Re: Fixed xloginsert_locks for 9.4
Re: Fixed xloginsert_locks for 9.4
List pgsql-hackers
On Fri, Oct  3, 2014 at 03:00:56PM -0300, Arthur Silva wrote:
>     I remember Informix had a setting that had no description except "try
>     different values to see if it helps performance" --- we don't want to do
>     that.
> 
>     What if we emit a server message if the setting is too low?  That's how
>     we handle checkpoint_segments.
> 
> Not all GUC need to be straight forward to tune.
> If the gains are worthy I don't see any reason not to have it.

Every GUC add complexity to the system because people have to understand
it to know if they should tune it.  No GUC is zero-cost.

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + Everyone has their own god. +



pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: replicating DROP commands across servers
Next
From: Bruce Momjian
Date:
Subject: Re: Fixed xloginsert_locks for 9.4