X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 59361D1B917 for ; Tue, 3 Feb 2004 15:38:04 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 72249-09 for ; Tue, 3 Feb 2004 11:38:03 -0400 (AST) Received: from mail.ez3pl.com (66-136-75-131.ded.swbell.net [66.136.75.131]) by svr1.postgresql.org (Postfix) with ESMTP id 22F59D1B897 for ; Tue, 3 Feb 2004 11:38:00 -0400 (AST) Received: from kbarnard ([172.25.96.149]) by mail.ez3pl.com (8.11.2/8.11.2) with ESMTP id i13Fb2o22184 for ; Tue, 3 Feb 2004 09:37:02 -0600 From: "Kevin Barnard" To: Date: Tue, 03 Feb 2004 09:34:01 -0600 MIME-Version: 1.0 Subject: Re: Increasing number of PG connections. Message-ID: <401F6B09.32118.342102@localhost> In-reply-to: References: <401E8493.30458.332D5CEF@localhost> X-mailer: Pegasus Mail for Windows (v4.12a) Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT Content-description: Mail message body X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/42 X-Sequence-Number: 5566 On 2 Feb 2004 at 16:45, scott.marlowe wrote: > Do you have the cache set to write back or write through? Write through > can be a performance killer. But I don't think your RAID is the problem, > it looks to me like postgresql is doing a lot of I/O. When you run top, > do the postgresql processes show a lot of D status? That's usually waiting > on I/O > Actually I'm not sure. It's setup with the factory defaults from IBM. Actually when I start hitting the limit I was surprised to find only a few D status indicators. Most of the processes where sleeping. > what you want to do is get the machine to a point where the kernel cache > is about twice the size or larger, than the shared_buffers. I'd start at > 10000 shared buffers and 4096 sort mem and see what happens. If you've > still got >2 gig kernel cache at that point, then increase both a bit (2x > or so) and see how much kernel cache you've got. If your kernel cache > stays above 1Gig, and the machine is running faster, you're doing pretty > good. > I've set shared to 10000 and sort to 4096. I just have to wait until the afternoon before I see system load start to max out. Thanks for the tips I'm crossing my fingers. -- Kevin Barnard