[Babase] Postgresql server badly needs tuneing!
Karl O. Pinc
babase@www.eco.princeton.edu
Tue, 12 Oct 2004 13:46:23 -0500
Hi,
I see that shared_buffers (presumeably in postgresql.conf)
is set to the default, 64. This allocates only .5MB of
RAM (64 * 8KB blocks). They recommend a setting of several thousand
at least. I leave it to you to set it based on available RAM.
See:
http://www.postgresql.org/docs/7.3/static/runtime-config.html
You can send the server SIGHUP to reset this without interrupting
service.
I'd appreciate it if you'd get to it ASAP as I'm working
on improving performance and there's no point in proceeding
until the server's tuned.
Karl <kop@meme.com>
Free Software: "You don't pay back, you pay forward."
-- Robert A. Heinlein