Re: [SQL] Optimizing ORDER BY with indexes? - Mailing list pgsql-sql

From Dirk Lutzebaeck
Subject Re: [SQL] Optimizing ORDER BY with indexes?
Date
Msg-id 14462.60862.309797.178045@ampato.aeccom.com
Whole thread Raw
In response to Re: [SQL] Optimizing ORDER BY with indexes?  (Dirk Lutzebaeck <lutzeb@aeccom.com>)
List pgsql-sql
Dirk Lutzebaeck writes:> Dirk Lutzebaeck writes:>  > >  > I'm forced to used ORDER BY on large tables which then takes
quite> > long. Is there a chance to create/optimize an index for ORDER BY?>  > Or could I write an index method on my
own?How would it look like?>  > >  > Are there any other possiblities to speed up ORDER BY?> > Reading about indexes in
theBowman SQL book I think a > _clustered index_ is needed for the problem above.> Does Postgresql support these?
 

Ok, I'm talking to my self here:

man cluster

RTFM.

Dirk



pgsql-sql by date:

Previous
From: Dirk Lutzebaeck
Date:
Subject: Re: [SQL] Optimizing ORDER BY with indexes?
Next
From: Tom Lane
Date:
Subject: Re: [SQL] key set delete query