Re: SQL performance problems

Поиск
Список
Период
Сортировка
Искать
От
Alberto Caso
Тема
Re: SQL performance problems
Дата
Msg-id
1062368198.1052.34.camel@localhost
Ответ на
SQL performance problems (Rhaoni Chiu Pereira)
Список
Дерево обсуждения
SQL performance problems Rhaoni Chiu Pereira <rhaoni@sistemica.info>
Re: SQL performance problems Alberto Caso <alberto.caso@adaptia.net>
Re: SQL performance problems Alberto Caso <alberto.caso@adaptia.net>
Re: SQL performance problems Tom Lane <tgl@sss.pgh.pa.us>

	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


В списке pgsql-performance по дате отправления
От: Rob Nagler
Дата:
От: Tom Lane
Дата:
FAQ