Re: installation options... Please help...

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Steve Ackerman" <sacker3254(at)yahoo(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: installation options... Please help...
Date: 2000-10-04 05:51:09
Message-ID: 2626.970638669@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

"Steve Ackerman" <sacker3254(at)yahoo(dot)com> writes:
> setting the --maxbackends to 256 also changes the default buffers from 64 to
> 512, right? If not is this only done with the -B switch?

AFAIR, -N (--maxbackends) *only* sets the max # of backends. You should
also specify an appropriate number of shared buffers (-B). The
postmaster enforces a minimum -B setting of twice -N, but that's
probably on the low side --- if you're thinking -N of 100 or so,
I'd suggest -B of 500 to 1000, maybe more.

Feel free to experiment and report back on what seems to work well
for your application mix...

regards, tom lane

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Poul L. Christiansen 2000-10-04 06:47:40 Re: ODBC access with Windows 2000
Previous Message Jacob Joseph 2000-10-04 05:29:23 ODBC access with Windows 2000