Re: sudden drop in delete performance

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: sudden drop in delete performance
Дата
Msg-id 19823.1164815525@sss.pgh.pa.us
обсуждение исходный текст
Ответ на sudden drop in delete performance  ("surabhi.ahuja" <surabhi.ahuja@iiitb.ac.in>)
Список pgsql-general
Дерево обсуждения 
"surabhi.ahuja" <surabhi.ahuja@iiitb.ac.in> writes:
> I was using Postgres 8.0.0
> I have upgraded it to Postgres 8.1.5
> I have seen that the delete performance has degraded considerably.

Did you remember to re-ANALYZE your tables after transferring your database?
If so, what does EXPLAIN ANALYZE show for the slow delete?

            regards, tom lane

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

Предыдущее
От: Michal Taborsky - Internet Mall
Дата:
Сообщение: LOCK ... NOWAIT throws error
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Only MONO/WinForms is a way to go