Conservative postgresql.conf made by initdb?

From: rihad <rihad(at)mail(dot)ru>
To: pgsql-general(at)postgresql(dot)org
Subject: Conservative postgresql.conf made by initdb?
Date: 2007-12-05 06:45:27
Message-ID: 47564907.80401@mail.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

In postgresql.conf generated by initdb shared_buffers is set to 32MB
even though there was more available (see below; also ipcs shows
postgres is (and will be) the only shared memory user). Is this enough
or maybe it's less than ok? I don't know. What I do know is that MySQL
4.0.x uses 500-550 mb RAM for similar access patterns. Also,
max_connections preset to 40 is more than ok for our case. Is
max_fsm_pages = 204800 OK ? Should I increase it if I expect 15-20 gb
disk usage by db?

FreeBSD 7.0-BETA3 PostgreSQL 8.3 beta2

sysctl settings at the time initdb ran more or less resembled the
recommendations given here:
http://www.postgresql.org/docs/8.3/static/kernel-resources.html#SYSVIPC
namely:

kern.ipc.shmmax: 134217728
kern.ipc.shmmin: 1
kern.ipc.shmall: 32768
kern.ipc.shmseg: 128
kern.ipc.shmmni: 192
kern.ipc.semmns: 60
kern.ipc.semmsl: 60
kern.ipc.semmap: 256
kern.ipc.semvmx: 32767

Maybe I should increase shmall/shmmax and rerun initdb to maximize
performance of expectedly 25-30 concurrent connections, which are
"persistent" and hence many of which are idle at the low hours?

Thanks.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Robert Treat 2007-12-05 07:16:02 Re: Conservative postgresql.conf made by initdb?
Previous Message Ed Burgstaler 2007-12-05 06:28:04 Re: Older version of PGSQL help