Re: Vacuum duration + hint bits?

От: Tom Lane
Тема: Re: Vacuum duration + hint bits?
Дата: ,
Msg-id: 28104.1251414326@sss.pgh.pa.us
(см: обсуждение, исходный текст)
Ответ на: Vacuum duration + hint bits?  (bricklen)
Ответы: Re: Vacuum duration + hint bits?  (bricklen)
Список: pgsql-performance

bricklen <> writes:
> Hi, I have a question about a db-wide vacuum that I am running that is
> taking a much longer time than normal. We switched over to our warm standby
> server today -- which is virtually identical to the source db server -- and
> I initiated a "vacuum analyze verbose". Normally this process wouldn't take
> more than 6 hours, but so far we are well over 9 hours. I seem to recall
> reading in one of these pg lists that a db-wide vacuum of a new (?) database
> would go about setting the hint bits and cause a lot more disk IO than is
> normal. Is that a possible cause.

Yeah, it seems possible.  You could look at vmstat to see if there's
tons of write activity ...

            regards, tom lane


В списке pgsql-performance по дате сообщения:

От: bricklen
Дата:
Сообщение: Re: Vacuum duration + hint bits?
От: Joseph S
Дата:
Сообщение: What exactly is postgres doing during INSERT/UPDATE ?