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 2E129D1DA97 for ; Tue, 17 Feb 2004 07:42:53 +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 34187-10 for ; Tue, 17 Feb 2004 03:42:49 -0400 (AST) Received: from megazone.bigpanda.com (megazone.bigpanda.com [64.147.171.210]) by svr1.postgresql.org (Postfix) with ESMTP id AF1BAD1DA30 for ; Tue, 17 Feb 2004 03:42:47 -0400 (AST) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id 310B3357AB; Mon, 16 Feb 2004 23:42:48 -0800 (PST) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id 2FAB2357A4; Mon, 16 Feb 2004 23:42:48 -0800 (PST) Date: Mon, 16 Feb 2004 23:42:48 -0800 (PST) From: Stephan Szabo To: Saleem Burhani Baloch Cc: pgsql-performance@postgresql.org Subject: Re: Slow response of PostgreSQL In-Reply-To: <200402170624.i1H6O2u16022@ns2.khi.wol.net.pk> Message-ID: <20040216233912.L31376@megazone.bigpanda.com> References: <200402170624.i1H6O2u16022@ns2.khi.wol.net.pk> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/176 X-Sequence-Number: 5700 On Tue, 17 Feb 2004, Saleem Burhani Baloch wrote: > select count(*), sum(vl_ex_stax) , sum(qty) , unit from inv_detail group by unit; > on both databases. > PostgreSQL Machine > ****************** > P-III 600Mhz (Dell Precision 220) > 256 MB Ram (RD Ram) > 40 GB Baracuda Ext2 File System. > RedHat 7.2 > PostgreSQL 7.1.3-2 Besides the comments on the conf file already sent, 7.1.3 is many versions behind the current version and definately has some deficiencies either fully or partially corrected in later versions. All in all, I'd suggest going all the way to 7.4.1 since the hash aggregate stuff might help the queries you're running.