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.
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 |