Re: PostgreSQL 8.0 occasionally slow down

Поиск
Список
Период
Сортировка
От Greg Smith
Тема Re: PostgreSQL 8.0 occasionally slow down
Дата
Msg-id Pine.GSO.4.64.0707021819410.11762@westnet.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
On Fri, 29 Jun 2007, Ho Fat Tsang wrote:

> I noticed that for each time the pgsql slow down, there is a short
> period a process called "pdflush" eating up lot of I/O. I've goolgled
> and know it is a process for writing dirty pages back to the disk by the
> Linux kernel.

The pdflush documentation is really spread out, you may find my paper at
http://www.westnet.com/~gsmith/content/linux-pdflush.htm a good place to
start looking into that.

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD

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

Предыдущее
От: Nis Jørgensen
Дата:
Сообщение: Re: slow query
Следующее
От: Craig James
Дата:
Сообщение: Join with lower/upper limits doesn't scale well