Vacuum duration + hint bits?
От
bricklen
Тема
Vacuum duration + hint bits?
Дата
Msg-id
33b743250908271602v57e13ec3y4fc74a0727998bc5@mail.gmail.com
Список
Дерево обсуждения
Vacuum duration + hint bits? bricklen <bricklen@gmail.com>
Re: Vacuum duration + hint bits? Tom Lane <tgl@sss.pgh.pa.us>
Re: Vacuum duration + hint bits? bricklen <bricklen@gmail.com>
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.
Postgresql 8.2.13, RHEL5
Sorry, I realize I'm short on details, but I'm just running out the door and the thought about hint bits struck me.
Cheers!
Postgresql 8.2.13, RHEL5
Sorry, I realize I'm short on details, but I'm just running out the door and the thought about hint bits struck me.
Cheers!
В списке pgsql-performance по дате отправления
От: Greg Smith
Дата: