| 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: | Whole Thread | Raw Message | 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
| 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 |