Postgres Pro
Downloads
Home   >   mailing lists

Re: Fwd: Index on table when using DESC clause - Mailing list pgsql-performance

From Steinar H. Gunderson
Subject Re: Fwd: Index on table when using DESC clause
Date
Msg-id 20050523180352.GA23486@uio.no
Whole thread Raw
In response to Fwd: Index on table when using DESC clause  (Yves Vindevogel <yves.vindevogel@implements.be>)
Responses Re: Fwd: Index on table when using DESC clause
List pgsql-performance
Tree view 
On Mon, May 23, 2005 at 07:41:19PM +0200, Yves Vindevogel wrote:
> However, when I query my db using for instance   order by pages,
> documentname, it is very fast.
> If I use   order by pages desc, documentname, it is not fast at
> all, like it is not using the index properly at all.

Make an index on "pages desc, documentname asc".

/* Steinar */
--
Homepage: http://www.sesse.net/

pgsql-performance by date:

Previous
From: Yves Vindevogel
Date:
Subject: Fwd: Index on table when using DESC clause
Next
From: Yves Vindevogel
Date:
Subject: Re: Fwd: Index on table when using DESC clause