bricklen <bricklen@xxxxxxxxx> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
