Begin forwarded message:
> From: Yves Vindevogel <yves(dot)vindevogel(at)implements(dot)be>
> Date: Mon 23 May 2005 19:23:16 CEST
> To: pgsql-performance-owner(at)postgresql(dot)org
> Subject: Index on table when using DESC clause
>
> Hi,
>
> I have a table with multiple fields. Two of them are documentname and
> pages
> I have indexes on documentname and on pages, and one extra on
> documentname + pages
>
> 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.
>
> How can I avoid this ?
>
> Met vriendelijke groeten,
> Bien à vous,
> Kind regards,
>
> Yves Vindevogel
> Implements
>