Re: very very slow .....

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: very very slow .....
Дата
Msg-id 24899.986260747@sss.pgh.pa.us
обсуждение исходный текст
Ответ на very very slow .....  ("J.Fernando Moyano" <txinete@wanadoo.es>)
Список pgsql-sql
"J.Fernando Moyano" <txinete@wanadoo.es> writes:
> The execution time of certain queries is 20 or 30 times longer in 7.0.2 that 
> 6.5. (20 or 30 seconds where before it was 1 or 2 seconds !!!)

Have you done a VACUUM ANALYZE?

Other than that, there's no generic advice.  You'll need to provide some
details about the problem queries and the plans you get for them in 6.5
and 7.0.
        regards, tom lane


В списке pgsql-sql по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: using for rec inside a function: behavior very slow
Следующее
От: "Gerald Gutierrez"
Дата:
Сообщение: Appropriate indices to create for these queries