Re: Vacuum duration + hint bits?

Yeah, there's a lot. Way more than I am accustomed to seeing from the same
command on the previous server.

On Thu, Aug 27, 2009 at 4:05 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> bricklen <bricklen(at)gmail(dot)com> 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
>