From: Tom Lane <tgl@sss.pgh.pa.us>
To: Doug Y <dylists@ptd.net>
Cc: pgsql-performance@postgresql.org
Subject: Re: Tuning shared_buffers with ipcs ?
Date: Fri, 15 Oct 2004 13:51:05 -0400
Message-ID: <10905.1097862665@sss.pgh.pa.us> (raw)
In-Reply-To: <416FF5BF.8060200@ptd.net>
References: <416FF5BF.8060200@ptd.net>
Doug Y <dylists@ptd.net> writes:
> I've seen a couple references to using ipcs to help properly size
> shared_buffers.
I have not seen any such claim, and I do not see any way offhand that
ipcs could help.
> I tried all of the dash commands in the ipcs man page, and the only one
> that might give a clue is ipcs -t which shows the time the semaphores
> were last used. If you look at the example I give below, it appears as
> if I'm only using 4 of the 17 semaphores (PG was started on Oct 8).
This might tell you something about how many concurrent backends you've
used, but nothing about how many shared buffers you need.
regards, tom lane
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: tgl@sss.pgh.pa.us, dylists@ptd.net
Subject: Re: Tuning shared_buffers with ipcs ?
In-Reply-To: <10905.1097862665@sss.pgh.pa.us>
* 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