Skip site navigation (1) Skip section navigation (2)

Re: Vacuum duration + hint bits?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: bricklen <bricklen(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Vacuum duration + hint bits?
Date: 2009-08-27 23:05:26
Message-ID: 28104.1251414326@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-performance
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

In response to

Responses

pgsql-performance by date

Next:From: bricklenDate: 2009-08-28 00:19:42
Subject: Re: Vacuum duration + hint bits?
Previous:From: bricklenDate: 2009-08-27 23:02:15
Subject: Vacuum duration + hint bits?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group