Re: slow queries on large syslog table

How about clusterring? "CLUSTER indexname ON table"

>From: "colm ennis" <colm(dot)ennis(at)eircom(dot)net>
>To: "omid omoomi" <oomoomi(at)hotmail(dot)com>, <fiol(at)w3ping(dot)com>
>CC: <pgsql-general(at)postgresql(dot)org>
>Subject: Re: [GENERAL] slow queries on large syslog table
>Date: Fri, 14 Dec 2001 19:54:21 -0000
>
>hi omid,
>
>i have and it makes little difference to the query time or to the
>explain im afraid,
>
>colm
>
>-----Original Message-----
>From: omid omoomi [mailto:oomoomi(at)hotmail(dot)com]
>Sent: 14 December 2001 10:23
>To: colm(dot)ennis(at)eircom(dot)net; fiol(at)w3ping(dot)com
>Cc: pgsql-general(at)postgresql(dot)org
>Subject: Re: [GENERAL] slow queries on large syslog table
>
>
>hi,
>have you tried your queries with out order by clause?
>That might be significant.
>
>regards
>Omid Omoomi
>

_________________________________________________________________
Join the worlds largest e-mail service with MSN Hotmail.
http://www.hotmail.com