Re: 7.3 vs 7.2 - different query plan, bad performance

Поиск
Список
Период
Сортировка
Искать
От
Manfred Koizar
Тема
Re: 7.3 vs 7.2 - different query plan, bad performance
Дата
Msg-id
ugipevc89eaqk90s23n8kd2iut5uvskpk4@4ax.com
Ответ на
7.3 vs 7.2 - different query plan, bad performance (Ryszard Lach)
Список
Дерево обсуждения
7.3 vs 7.2 - different query plan, bad performance Ryszard Lach <siaco@autograf.pl>
Re: 7.3 vs 7.2 - different query plan, bad performance Bruno Wolff III <bruno@wolff.to>
Re: 7.3 vs 7.2 - different query plan, bad performance Manfred Koizar <mkoi-pg@aon.at>
Re: 7.3 vs 7.2 - different query plan, bad performance siaco@allegro.pl
Re: 7.3 vs 7.2 - different query plan, bad performance Manfred Koizar <mkoi-pg@aon.at>
Re: 7.3 vs 7.2 - different query plan, bad performance Ryszard Lach <siaco@autograf.pl>
Re: 7.3 vs 7.2 - different query plan, bad performance Tom Lane <tgl@sss.pgh.pa.us>
Re: 7.3 vs 7.2 - different query plan, bad performance Manfred Koizar <mkoi-pg@aon.at>
Re: 7.3 vs 7.2 - different query plan, bad performance Ryszard Lach <siaco@autograf.pl> 
On Fri, 13 Jun 2003 20:45:06 +0200, Ryszard Lach 
wrote:
>I have a problem with performance after upgrading from 7.2 to 7.3.

Try
	VACUUM ANALYSE;

and then re-run your query.  If it is still slow, post the new EXPLAIN
ANALYSE output here.

Servus
 Manfred
В списке pgsql-performance по дате отправления
Предыдущее
От: Tom Lane
Дата:
Следующее
От: Tomaz Borstnar
Дата:
FAQ