Re: Heavy write activity on first vacuum of fresh TOAST data

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: Heavy write activity on first vacuum of fresh TOAST data
Дата
Msg-id 47624A8E.EE98.0025.0@wicourts.gov
обсуждение исходный текст
Ответ на Re: Heavy write activity on first vacuum of fresh TOAST data  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
>>> On Fri, Dec 14, 2007 at  1:42 AM, in message <29185.1197618162@sss.pgh.pa.us>,
Tom Lane <tgl@sss.pgh.pa.us> wrote:

> My feeling is that vacuum's purpose in life is to offload maintenance
> cycles from foreground queries, so we should be happy to have it setting
> all the hint bits.

Absolutely.

> If Kevin doesn't like the resultant I/O load then he
> should use the vacuum_cost_delay parameters to dial down vacuum speed.

It's not that I don't like it -- I'm often called upon to diagnose
issues, and understanding the dynamics of things like this helps me
interpret what I'm seeing.  No complaint here.

-Kevin




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

Предыдущее
От: "Roberts, Jon"
Дата:
Сообщение: viewing source code
Следующее
От: Bill Moran
Дата:
Сообщение: Re: viewing source code