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 58BBE3A1D66 for ; Sun, 2 Jan 2005 14:08:38 +0000 (GMT) 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 80954-01 for ; Sun, 2 Jan 2005 14:08:28 +0000 (GMT) Received: from mail3.panix.com (mail3.panix.com [166.84.1.74]) by svr1.postgresql.org (Postfix) with ESMTP id 804263A2C40 for ; Sun, 2 Jan 2005 14:08:28 +0000 (GMT) Received: from panix1.panix.com (panix1.panix.com [166.84.1.1]) by mail3.panix.com (Postfix) with ESMTP id B00D0981C4; Sun, 2 Jan 2005 09:08:28 -0500 (EST) Received: (from adler@localhost) by panix1.panix.com (8.11.6p3/8.8.8/PanixN1.1) id j02E8Sx06526; Sun, 2 Jan 2005 09:08:28 -0500 (EST) Date: Sun, 2 Jan 2005 09:08:28 -0500 From: Michael Adler To: amrit@health2.moph.go.th Cc: pgsql-performance@postgresql.org Subject: Re: Low Performance for big hospital server .. Message-ID: <20050102140828.GA21826@pobox.com> References: <1104634472.41d762681b548@webmail.moph.go.th> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1104634472.41d762681b548@webmail.moph.go.th> User-Agent: Mutt/1.4.2.1i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200501/3 X-Sequence-Number: 9693 On Sun, Jan 02, 2005 at 09:54:32AM +0700, amrit@health2.moph.go.th wrote: > postgresql 7.3.2-1 with RH 9 on a mechine of 2 Xeon 3.0 Ghz and ram of 4 Gb. You may want to try disabling hyperthreading, if you don't mind rebooting. > grew up to 3.5 Gb and there were more than 160 concurent connections. Looks like your growing dataset won't fit in your OS disk cache any longer. Isolate your most problematic queries and check out their query plans. I bet you have some sequential scans that used to read from cache but now need to read the disk. An index may help you. More RAM wouldn't hurt. =) -Mike Adler