Re: Bug? 8.0 does not use partial index

From: John Hansen <john(at)geeknet(dot)com(dot)au>
To: Palle Girgensohn <girgen(at)pingpong(dot)net>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: Bug? 8.0 does not use partial index
Date: 2005-01-14 00:52:38
Message-ID: 1105663959.24775.14.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Palle Girgensohn 2005-01-14 01:24:31 Re: Bug? 8.0 does not use partial index
Previous Message Palle Girgensohn 2005-01-14 00:52:30 Re: Bug? 8.0 does not use partial index