Quick Links

Re: SQL performance problems

From:	Alberto Caso <alberto(dot)caso(at)adaptia(dot)net>
To:	Rhaoni Chiu Pereira <rhaoni(at)sistemica(dot)info>
Cc:	PostgreSQL Performance <pgsql-performance(at)postgresql(dot)org>
Subject:	Re: SQL performance problems
Date:	2003-08-31 22:16:38
Message-ID:	1062368198.1052.34.camel@localhost
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-performance

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:

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(dot)caso(at)adaptia(dot)net

	From	Date	Subject
Next Message	Tom Lane	2003-08-31 23:12:50	Re: How to force Nested Loop plan?
Previous Message	Rob Nagler	2003-08-31 00:08:32	Re: How to force Nested Loop plan?