Re: sudden drop in delete performance

Поиск
Список
Период
Сортировка
От Ben Trewern
Тема Re: sudden drop in delete performance
Дата
Msg-id ekk2qk$121p$1@news.hub.org
обсуждение исходный текст
Ответ на sudden drop in delete performance  ("surabhi.ahuja" <surabhi.ahuja@iiitb.ac.in>)
Список pgsql-general
Дерево обсуждения
Did you 'vacuum analyze' after you did the update?
 
Make sure you have the correct indexes in place on your foreign keys.
 
Did you have fsync off on your previous installation?
 
Give some more details and I'm sure people will be able to give better advice than me.
 
Regards,
 
Ben
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.
 
Nothing else has changed.
 
Please help
thanks
regards
 
Surabhi

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

Предыдущее
От: Dave Bodenstab
Дата:
Сообщение: Create index on array element?
Следующее
От: "hubert depesz lubaczewski"
Дата:
Сообщение: Re: postgresql 8.2 rc1 - crash