Conservative postgresql.conf made by initdb? - Mailing list pgsql-general

From rihad
Subject Conservative postgresql.conf made by initdb?
Date
Msg-id 47564907.80401@mail.ru
Whole thread Raw
Responses Re: Conservative postgresql.conf made by initdb?
List 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.

pgsql-general by date:

Previous
From: Keaton Adams
Date:
Subject: Re: Server crashed and now experiencing slow running queries
Next
From: Robert Treat
Date:
Subject: Re: Conservative postgresql.conf made by initdb?