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 EA1F432AEF3 for ; Wed, 20 Oct 2004 05:35:34 +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 81047-03 for ; Wed, 20 Oct 2004 04:35:33 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id CB93632AEFF for ; Wed, 20 Oct 2004 05:35:32 +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 i9K4ZVb6029977; Wed, 20 Oct 2004 00:35:31 -0400 (EDT) To: Josh Close Cc: POSTGRES-PERFORMANCE Subject: Re: how much mem to give postgres? In-reply-to: <4a0cafe2041019153133f854e9@mail.gmail.com> References: <4a0cafe2041019153133f854e9@mail.gmail.com> Comments: In-reply-to Josh Close message dated "Tue, 19 Oct 2004 17:31:59 -0500" Date: Wed, 20 Oct 2004 00:35:31 -0400 Message-ID: <29976.1098246931@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/306 X-Sequence-Number: 8782 Josh Close writes: > I'm trying to figure out what I need to do to get my postgres server > moving faster. It's just crawling right now. I suspect that fooling with shared_buffers is entirely the wrong tree for you to be barking up. My suggestion is to be looking at individual queries that are slow, and seeing how to speed those up. This might involve adding indexes, or tweaking the query source, or adjusting planner parameters, or several other things. EXPLAIN ANALYZE is your friend ... regards, tom lane