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

Re: [GENERAL] Multiple Indexing, performance impact

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Daniel Åkerud <zilch(at)home(dot)se>, PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [GENERAL] Multiple Indexing, performance impact
Date: 2001-06-23 17:17:27
Message-ID: 7885.993316647@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackers
Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> No.  I'm concerned that PostgreSQL should work out of the box for
> everyone.

Agreed.

> And I would prefer that PostgreSQL works the same on every
> platform out of the box.

Well, I'm not sure that we need to take that as far as saying that
default NBuffers can't vary across platforms.  It's not like we're
adding or subtracting functionality.  All I want is to have the default
setup tuned a little better than it is now.

> Obviously we've already lost this on systems
> where the default shmmax is 512kB (SCO OpenServer, Unixware) or 1 MB
> (Solaris), and reducing the parameters is clearly not an option.  But if a
> plurality of systems have the default set at 4 MB or 8 MB then we should
> stop there so we don't upset a large fraction of users.

Making sure that default NBuffers stays under the platform's default
SHMMAX would accomplish that goal at least as well, probably better
than trying to have a one-size-fits-all default; especially if we've
already failed to do the latter.

> Btw., do we have any data on how appropriate wal_buffers = 8 is?

Not that I've seen.  It looks like a rather ad-hoc choice to me...

			regards, tom lane

In response to

pgsql-hackers by date

Next:From: Peter EisentrautDate: 2001-06-23 17:28:55
Subject: Re: psql+openssl+uniware7
Previous:From: Olivier PRENANTDate: 2001-06-23 16:49:38
Subject: Re: psql+openssl+uniware7

pgsql-general by date

Next:From: Peter EisentrautDate: 2001-06-23 18:46:58
Subject: Re: TCP/IP Sockets, UNIX Sockets
Previous:From: Svenne KrapDate: 2001-06-23 17:04:22
Subject: Re: Speed...

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