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 20141003220856.GL14522@momjian.us
Whole thread Raw
In response to Re: Fixed xloginsert_locks for 9.4  (Andres Freund <andres@2ndquadrant.com>)
Responses Re: Fixed xloginsert_locks for 9.4
List pgsql-hackers
On Fri, Oct  3, 2014 at 11:58:14PM +0200, Andres Freund wrote:
> On 2014-10-03 17:55:19 -0400, Tom Lane wrote:
> > Andres Freund <andres@2ndquadrant.com> writes:
> > > On 2014-10-03 12:40:21 -0400, Bruce Momjian wrote:
> > >> Well, I think the issue is that having a GUC that can't reasonably be
> > >> tuned by 95% of our users is nearly useless.  Few users are going to run
> > >> benchmarks to see what the optimal value is.
> > 
> > > It's possible to convince customers to play with a performance
> > > influencing parameter and see how the results are. Even in
> > > production.
> > 
> > I'm a bit dubious that people will be willing to experiment in production
> > with a GUC that requires a database restart to change.
> 
> I've convinced customers to restart databases with several different
> shared_buffers settings... So I'm pretty sure it's possible, in *some*
> cases, for xloginsert_slots.
> 
> And even if it's just test/pre-production machines - they're not going
> to benchmark settings they can't reasonably set in production.

Do we really want to expose a setting a few of us _might_ ask customers
to change?  I don't think so --- create a custom build if you want that.

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



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Dynamic LWLock tracing via pg_stat_lwlock (proof of concept)
Next
From: Andres Freund
Date:
Subject: Re: Fixed xloginsert_locks for 9.4