Re: PostgreSQL 8.0 occasionally slow down

Поиск
Список
Период
Сортировка
От Richard Huxton
Тема Re: PostgreSQL 8.0 occasionally slow down
Дата
Msg-id 46836B66.7050109@archonet.com
обсуждение исходный текст
Ответ на Re: PostgreSQL 8.0 occasionally slow down  ("Ho Fat Tsang" <namiwf@gmail.com>)
Ответы Re: PostgreSQL 8.0 occasionally slow down  ("Ho Fat Tsang" <namiwf@gmail.com>)
Список pgsql-performance
Ho Fat Tsang wrote:
> Hi Richard,
>
>   I have tuned the checkpoint_timeout to 30 second which is ten times less
> than default and the issue is still reproduced. Do you have any recommended
> configuration for WAL ?

If you look at the output of "vmstat 10" and "iostat -m 10" (I'm
assuming you're on Linux) does it show your I/O peaking every three
minutes? I might have been wrong about the cause.

--
   Richard Huxton
   Archonet Ltd

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

Предыдущее
От: "Ho Fat Tsang"
Дата:
Сообщение: Re: PostgreSQL 8.0 occasionally slow down
Следующее
От: Chris
Дата:
Сообщение: Re: update query taking too long