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

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: installation options... Please help...
Дата
Msg-id
2626.970638669@sss.pgh.pa.us
Ответ на
Список
Дерево обсуждения
installation options "Steve Ackerman" <sacker3254@yahoo.com>
RE: installation options... Please help... "Steve Ackerman" <sacker3254@yahoo.com>
Re: installation options... Please help... Tom Lane <tgl@sss.pgh.pa.us>
"Steve Ackerman"  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
В списке pgsql-novice по дате отправления
От: Jacob Joseph
Дата:
Сообщение: ODBC access with Windows 2000
От: Poul L. Christiansen
Дата:
FAQ