Re: SQL performance issue with PostgreSQL compared to

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Achilleus Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>
Cc: Jeff Self <jself(at)nngov(dot)com>, <pgsql-sql(at)postgresql(dot)org>
Subject: Re: SQL performance issue with PostgreSQL compared to
Date: 2002-06-21 00:00:26
Message-ID: 200206201700.26725.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


Achilleus,

> > > The pgsql db is indexed on the
> > > 'authuser' field, and I've run 'analyze logfile'.
> >
> > He also needs to index the bytes field and the traffic field. And run
> ^^^^^^^
>
> Index on an aggregate function???
>
> I though we could only index plain normal column iscachable functions.

No, you're correct. I meant just to index on the bytes field.

--
-Josh Berkus

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Josh Berkus 2002-06-21 00:03:52 Re: how to sort a birthday list ?
Previous Message David Stanaway 2002-06-20 21:32:50 Re: how to sort a birthday list ?