Re: Segment best size

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: Segment best size
Дата
Msg-id CAMkU=1yCTL0Op4Z3uRek5sxLiga_gXQo_NHe5pEUC62Zw1tb-w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Segment best size  (Rodrigo Barboza <rodrigombufrj@gmail.com>)
Ответы Re: Segment best size  (Rodrigo Barboza <rodrigombufrj@gmail.com>)
Список pgsql-performance
On Sat, Apr 13, 2013 at 10:29 AM, Rodrigo Barboza <rodrigombufrj@gmail.com> wrote:


I was receiving warning messages of pgstat timeout.
I started looking for the solution for this problem and this doubt came out.
But it doesn't seem to be the problem.

Usually that just means that you are dirtying pages faster than your hard drives can write them out, leading to IO contention.  Sometimes you can do something about this by changing the work-load to dirty pages in more compact regions, or by changing the configuration.  Often the only effective thing you can do is buy more hard-drives.

Cheers,

Jeff

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

Предыдущее
От: Rikard Pavelic
Дата:
Сообщение: Re: limit is sometimes not pushed in view with order
Следующее
От: Jeff Janes
Дата:
Сообщение: Re: slow bitmap heap scans on pg 9.2