Re: slow queries, possibly disk io

On 5/31/05, Martin Fandel <martin(dot)fandel(at)alphyra-evs(dot)de> wrote:
> In the documentation of
> http://www.powerpostgresql.com/Downloads/annotated_conf_80.html
> is the shared_buffers set to 1/3 of the availble RAM. You're set
> 50000*8/1024=391 MB SHMEM. The effective_cache_size in your
> configuration is 450000*8/1024=3516 MB SHMEM. That's 3907MB
> of RAM but you have less than 2048MB availble.

I wrote that wrong, there is actually 4 gigs of ram available.

>
> What value do you have in /proc/sys/kernel/shmmax?
>
> I'm really new at using postgres and i have not many experience
> but maybe you can try to use 1/3 (682MB/87424)for shared_buffers
> and 2/3 (1365MB/174720) for the effective_cache_size? But i these
> settings are to high too.
>
> best regards
> Martin