Skip site navigation (1) Skip section navigation (2)

Re: Spinlock performance improvement proposal

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Justin Clift <justin(at)postgresql(dot)org>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Spinlock performance improvement proposal
Date: 2001-10-01 15:41:44
Message-ID: 200110011541.f91Ffit19871@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
> Tom Lane wrote:
> > 
> <snip>
> > I think the default NBuffers (64) is too low to give meaningful
> > performance numbers, too.  I've been thinking that maybe we should
> > raise it to 1000 or so by default.  This would trigger startup failures
> > on platforms with small SHMMAX, but we could tell people to use -B until
> > they get around to fixing their kernel settings.  It's been a long time
> > since we fit into a 1-MB shared memory segment at the default settings
> > anyway, so maybe it's time to select somewhat-realistic defaults.
> > What we have now is neither very useful nor the lowest common
> > denominator...
> 
> How about a startup error message which gets displayed when used with
> untuned settings (i.e. the default settings), maybe unless an option
> like -q (quiet) is given?
> 
> My thought is the server should operate, but let the new/novice admin
> know they need to configure PostgreSQL properly.  Would probably be a
> good reminder for experienced admins if they forget too.
> 
> Maybe something simple like pg_ctl shell script message, or something
> proper like a postmaster start-up check.

Yes, this seems like the way to go, probably something in the postmaster
log file.  For single-user developers, we want it to start but we want
production machines to tune it. In fact, picking a higher number for
these values may be almost as far off as our defaults.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

In response to

Responses

pgsql-hackers by date

Next:From: Tatsuo IshiiDate: 2001-10-01 15:42:42
Subject: Re: Problem on AIX with current
Previous:From: Vince VielhaberDate: 2001-10-01 15:36:56
Subject: Re: developer's faq

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group