Skip site navigation (1) Skip section navigation (2)

Re: Slow response of PostgreSQL

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: Saleem Burhani Baloch <peseek(at)khi(dot)wol(dot)net(dot)pk>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Slow response of PostgreSQL
Date: 2004-02-17 07:42:48
Message-ID: 20040216233912.L31376@megazone.bigpanda.com (view raw or flat)
Thread:
Lists: pgsql-performance
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.


In response to

pgsql-performance by date

Next:From: Tom LaneDate: 2004-02-17 07:45:40
Subject: Re: Slow response of PostgreSQL
Previous:From: Christopher Kings-LynneDate: 2004-02-17 06:59:08
Subject: Re: Slow response of PostgreSQL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group