From: Josh Close <narshe@gmail.com>
To: POSTGRES-PERFORMANCE <pgsql-performance@postgresql.org>
Subject: Re: slow queries, possibly disk io
Date: Tue, 31 May 2005 11:36:49 -0500
Message-ID: <4a0cafe2050531093631c725e3@mail.gmail.com> (raw)
In-Reply-To: <1117551659.7612.85.camel@fandelm.ecommit.de>
References: <4a0cafe20505310617d803a0c@mail.gmail.com>
<1117551659.7612.85.camel@fandelm.ecommit.de>
On 5/31/05, Martin Fandel <martin.fandel@alphyra-evs.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: narshe@gmail.com
Subject: Re: slow queries, possibly disk io
In-Reply-To: <4a0cafe2050531093631c725e3@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox