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 [EMAIL PROTECTED]
signature.asc
Description: Esta parte del mensaje =?ISO-8859-1?Q?est=E1?= firmadadigitalmente