Skip site navigation (1) Skip section navigation (2)

Re: Tuning shared_buffers with ipcs ?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Doug Y <dylists(at)ptd(dot)net>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Tuning shared_buffers with ipcs ?
Date: 2004-10-15 17:51:05
Message-ID: 10905.1097862665@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-performance
Doug Y <dylists(at)ptd(dot)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

In response to

Responses

pgsql-performance by date

Next:From: Tom LaneDate: 2004-10-15 17:55:11
Subject: Re: [PERFORM] Performance on Win32 vs Cygwin
Previous:From: Steve AtkinsDate: 2004-10-15 17:19:48
Subject: Re: Does PostgreSQL run with Oracle?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group