| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-02-17 07:45:40 | Re: Slow response of PostgreSQL |
| Previous Message | Christopher Kings-Lynne | 2004-02-17 06:59:08 | Re: Slow response of PostgreSQL |