Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group