On 3/19/07, Tom Lane <tgl@sss.pgh.pa.us> 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
