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 по дате отправления