Re: problems with slow insert/delete queries/lot of disk write i/o in postgresql 7.2.4

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: problems with slow insert/delete queries/lot of disk write i/o in postgresql 7.2.4
Дата
Msg-id 11032.1119937525@sss.pgh.pa.us
обсуждение исходный текст
Ответ на problems with slow insert/delete queries/lot of disk write i/o in postgresql 7.2.4  (Alexander Korobov <akorobov@gmail.com>)
Список pgsql-general
Alexander Korobov <akorobov@gmail.com> writes:
> We are having strange problem on production system with very slow
> insert/delete commands and huge cpu and disk write activity spikes  in
> postgresql 7.2.4.

The first thing you should consider, if you are concerned about
performance, is adopting a less obsolete version of Postgres.

As a stopgap, increasing the checkpoint interval parameters might
help some.

            regards, tom lane

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

Предыдущее
От: Gnanavel Shanmugam
Дата:
Сообщение: Re: Generate a list of (days/hours) between two dates
Следующее
От: Tom Lane
Дата:
Сообщение: Re: DANGER Windows version might hurt you