Re: SQL performance issue with PostgreSQL compared to

On Wed, 19 Jun 2002, Josh Berkus wrote:

>  > 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.

Am i missing something?

> 
> -Josh Berkus
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
> 

-- 
Achilleus Mantzios
S/W Engineer
IT dept
Dynacom Tankers Mngmt
tel:    +30-10-8981112
fax:    +30-10-8981877
email:  achill@matrix.gatewaynet.com       mantzios@softlab.ece.ntua.gr