pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Stephan Szabo <sszabo@megazone.bigpanda.com>
To: Saleem Burhani Baloch <peseek@khi.wol.net.pk>
Cc: pgsql-performance@postgresql.org
Subject: Re: Slow response of PostgreSQL
Date: Mon, 16 Feb 2004 23:42:48 -0800 (PST)
Message-ID: <20040216233912.L31376@megazone.bigpanda.com> (raw)
In-Reply-To: <200402170624.i1H6O2u16022@ns2.khi.wol.net.pk>
References: <200402170624.i1H6O2u16022@ns2.khi.wol.net.pk>

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.




view thread (18+ messages)  latest in thread

Message-ID: <20040216233912.L31376@megazone.bigpanda.com>
Permalink:  ../20040216233912.L31376@megazone.bigpanda.com/
Also on:    postgresql.org/message-id/20040216233912.L31376@megazone.bigpanda.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: sszabo@megazone.bigpanda.com, peseek@khi.wol.net.pk
  Subject: Re: Slow response of PostgreSQL
  In-Reply-To: <20040216233912.L31376@megazone.bigpanda.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox