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