On 3/19/07, Tom Lane <[EMAIL PROTECTED]> wrote:
Not if you have an index on lower(col) which one supposes you'd have
anyway for such an application.  Or are you running an ancient PG
release?


Yes, you're right. Looking at my history I can't find what my error
was - I analyzed the table several times to be sure. As I was playing
with the production db and a 8.2.3 db, perhaps I missed a command on
one of the db server.

Anyway, the estimates are accurate now.

Thanks for your help.

--
Guillaume

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Reply via email to