From: | Achilleus Mantzios <achill(at)matrix(dot)gatewaynet(dot)com> |
---|---|
To: | Josh Berkus <josh(at)agliodbs(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-20 07:16:11 |
Message-ID: | Pine.LNX.4.44.0206201014100.12927-100000@matrix.gatewaynet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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(at)postgresql(dot)org)
>
--
Achilleus Mantzios
S/W Engineer
IT dept
Dynacom Tankers Mngmt
tel: +30-10-8981112
fax: +30-10-8981877
email: achill(at)matrix(dot)gatewaynet(dot)com
mantzios(at)softlab(dot)ece(dot)ntua(dot)gr
From | Date | Subject | |
---|---|---|---|
Next Message | Gaetano Mendola | 2002-06-20 07:25:44 | Re: Rows affected |
Previous Message | Janning Vygen | 2002-06-20 06:27:07 | Re: Joining three data sources. |