[Babase] Postgresql server badly needs tuneing!
Susan Alberts
babase@www.eco.princeton.edu
Wed, 13 Oct 2004 11:37:30 +0300
Stephanie, since you'll be seeing Hunter in person maybe you can
follow up onthis?
Thanks,
Susan
>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
>_______________________________________________
>Babase mailing list
>Babase@www.eco.princeton.edu
>http://www.eco.princeton.edu/mailman/listinfo/babase
--
--------------------------------------------------------------------------------------------------------------------------------------
Susan Alberts, Department of Biology, Duke University, Box 90338,
Durham NC 27708
919-660-7272 (phone), 919-660-7293 (FAX)