Postgres Pro
Downloads
Home   >   mailing lists

Re: Limit clause not using index - Mailing list pgsql-performance

From Tom Lane
Subject Re: Limit clause not using index
Date
Msg-id 11563.1119367854@sss.pgh.pa.us
Whole thread Raw
In response to Limit clause not using index  (Yves Vindevogel <yves.vindevogel@implements.be>)
List pgsql-performance
Tree view 
Yves Vindevogel <yves.vindevogel@implements.be> writes:
>     create index ixPrintjobsLoginDescEventdateDesceventtime on
> tblPrintjobs (loginuser, desceventdate, desceventtime) ;

Hmm, that certainly looks like it should match the query.  What happens
to the EXPLAIN output if you do "set enable_sort = false"?

            regards, tom lane

pgsql-performance by date:

Previous
From: John A Meinel
Date:
Subject: Re: Another question on indexes (drop and recreate)
Next
From: Yves Vindevogel
Date:
Subject: Re: Another question on indexes (drop and recreate)