Postgres Pro
Downloads
Home   >   mailing lists

Optimizing ORDER BY with indexes? - Mailing list pgsql-sql

From Dirk Lutzebaeck
Subject Optimizing ORDER BY with indexes?
Date
Msg-id 14462.57679.783969.863812@ampato.aeccom.com
Whole thread Raw
Responses Re: [SQL] Optimizing ORDER BY with indexes?  (Dirk Lutzebaeck <lutzeb@aeccom.com>)
List pgsql-sql
Tree view 
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?

Dirk

pgsql-sql by date:

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