Horton

Re: Slow query problem

Richard Huxton <dev@archonet.com>

View thread
From: Richard Huxton <dev@archonet.com>
To: Dennis Björklund <db@zigo.dhs.org>, Bradley Tate <btate@objectmastery.com>
Cc: pgsql-performance@postgresql.org
Date: 2004-01-09T08:54:46Z
Lists: pgsql-performance 
On Friday 09 January 2004 07:29, Dennis Björklund wrote:
> On Thu, 8 Jan 2004, Bradley Tate wrote:
> >
> > select invheadref, invprodref, sum(units)
> > from invtran
> > group by invheadref, invprodref

> For the above query, shouldn't you have one index for both columns
> (invheadref, invprodref). Then it should not need to sort at all to do the
> grouping and it should all be fast.

Not sure if that would make a difference here, since the whole table is being 
read. 

-- 
  Richard Huxton
  Archonet Ltd