[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)