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 0418553208 for ; Mon, 28 Mar 2005 19:39:50 +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 37749-07 for ; Mon, 28 Mar 2005 18:39:40 +0000 (GMT) Received: from mars.interactivemediafactory.net (mars.imfeurope.net [194.2.222.161]) by svr1.postgresql.org (Postfix) with ESMTP id 2D11053202 for ; Mon, 28 Mar 2005 19:39:36 +0100 (BST) Received: from JC-8600.directinfos.com (localhost [127.0.0.1]) by mars.interactivemediafactory.net (8.12.11/8.12.11) with ESMTP id j2SIdVRf061164; Mon, 28 Mar 2005 20:39:32 +0200 (CEST) (envelope-from jc@directinfos.com) Message-Id: <6.2.0.14.0.20050328203405.052aa7c0@pop.interactivemediafactory.net> X-Mailer: QUALCOMM Windows Eudora Version 6.2.0.14 Date: Mon, 28 Mar 2005 20:39:21 +0200 To: Patrick Hatcher From: Jacques Caron Subject: Re: Sluggish server performance Cc: pgsql-performance@postgresql.org In-Reply-To: References: Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200503/606 X-Sequence-Number: 11311 Hi, At 20:20 28/03/2005, Patrick Hatcher wrote: >I'm experiencing extreme load issues on my machine anytime I have more than >40 users connected to the database. The majority of the users appear to be >in an idle state according TOP, but if more than3 or more queries are ran >the system slows to a crawl. The queries don't appear to the root cause >because they run fine when the load drops. I also doing routine vacuuming >on the tables. > >Is there some place I need to start looking for the issues bogging down the >server? Check that your queries use optimal plans, which usually (but not always) means they should use indexes rather than sequential scans. You can check for this by using EXPLAIN or EXPLAIN ANALYZE . You can also check the pg_stat_* and pg_statio_* tables to get a feel of what kind of accesses are done. You also might want to find out if your system is limited by IO or by the CPU. Most probably the former. You can also check the "performance tips" section of the manual. Also you shared_buffers setting seems to be pretty low given your configuration. Hope that helps, Jacques.