How about clusterring? "CLUSTER indexname ON table"
>From: "colm ennis" <colm.ennis@eircom.net>
>To: "omid omoomi" <oomoomi@hotmail.com>, <fiol@w3ping.com>
>CC: <pgsql-general@postgresql.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@hotmail.com]
>Sent: 14 December 2001 10:23
>To: colm.ennis@eircom.net; fiol@w3ping.com
>Cc: pgsql-general@postgresql.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 world�s largest e-mail service with MSN Hotmail.
http://www.hotmail.com