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

From Andrew Lazarus
Subject Re: Fwd: Index on table when using DESC clause
Date
Msg-id 42923CA3.1040306@pillette.com
Whole thread Raw
In response to Fwd: Index on table when using DESC clause  (Yves Vindevogel <yves.vindevogel@implements.be>)
List pgsql-performance
As far as I know, to use a straight index Postgres requires either

ORDER BY pages, description -- or --
ORDER BY pages DESC, description DESC.

If you want the results by pages DESC, description ASC, then you have to
make an index on an expression or define your own operator or something
esoteric like that. I would think the ability to have an index where the
columns don't all collate in the same direction would be an easy feature
to add.

Attachment

pgsql-performance by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: Fwd: Index on table when using DESC clause
Next
From: Simon Riggs
Date:
Subject: Re: Tuning planner cost estimates