Re: Limit clause not using index

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Yves Vindevogel <yves(dot)vindevogel(at)implements(dot)be>
Cc: pgsql-performance(at)postgreSQL(dot)org
Subject: Re: Limit clause not using index
Date: 2005-06-21 15:30:54
Message-ID: 11563.1119367854@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Yves Vindevogel <yves(dot)vindevogel(at)implements(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Amit V Shah 2005-06-21 15:46:59 Re: Do Views execute underlying query everytime ??
Previous Message Yves Vindevogel 2005-06-21 15:28:20 Re: Another question on indexes (drop and recreate)