Hi,
Estimated and actual rows differ a lot. Did you a VACUUM ANALYZE so
that the optimizer could update its statistics?
Also it would be great if you could provide more information, as your
PostgreSQL version, your table and indexes descriptions, etc. Have a
look at:
http://techdocs.postgresql.org/guides/SlowQueryPostingGuidelines
Please excuse me if you have already done it. I had a quick look at the
list's archives and didn't found it in your prior posts.
Regards,
--
Alberto Caso Palomino
Adaptia Soluciones Integrales
http://www.adaptia.net
alberto.caso@adaptia.net