> > 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 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org