Re: Bug? 8.0 does not use partial index - Mailing list pgsql-hackers

From John Hansen
Subject Re: Bug? 8.0 does not use partial index
Date
Msg-id 1105663959.24775.14.camel@localhost.localdomain
Whole thread Raw
In response to Re: Bug? 8.0 does not use partial index  (Palle Girgensohn <girgen@pingpong.net>)
Responses Re: Bug? 8.0 does not use partial index  (Palle Girgensohn <girgen@pingpong.net>)
List pgsql-hackers
> > Dunno if you're desperate enough to try that ... but it does seem to work.

if yo're going to hack anyway, then why not just simply tell the planner
that you know better and that it should use the index, regardles of the
stats collected?

set enable_seqscan=false;
<your original query here>;
set enable_seqscan=true;

... JOhn



pgsql-hackers by date:

Previous
From: Palle Girgensohn
Date:
Subject: Re: Bug? 8.0 does not use partial index
Next
From: Michael Fuhr
Date:
Subject: Re: Slow PL/pgSQL 8.0.RC5 (7.4.6. 3times faster)