X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 50680329FBD for ; Fri, 15 Oct 2004 18:51:12 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 10339-01 for ; Fri, 15 Oct 2004 17:51:06 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id E97EE32A07C for ; Fri, 15 Oct 2004 18:51:05 +0100 (BST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id i9FHp50c010906; Fri, 15 Oct 2004 13:51:05 -0400 (EDT) To: Doug Y Cc: pgsql-performance@postgresql.org Subject: Re: Tuning shared_buffers with ipcs ? In-reply-to: <416FF5BF.8060200@ptd.net> References: <416FF5BF.8060200@ptd.net> Comments: In-reply-to Doug Y message dated "Fri, 15 Oct 2004 12:07:27 -0400" Date: Fri, 15 Oct 2004 13:51:05 -0400 Message-ID: <10905.1097862665@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/225 X-Sequence-Number: 8701 Doug Y 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