vacuum full suddently took extremely long - Mailing list pgsql-admin

From Bert
Subject vacuum full suddently took extremely long
Date
Msg-id CAFCtE1=KN658tOca3RYDSPLsfOxJrkoySvWdY0jm+3ee9c8gkg@mail.gmail.com
Whole thread Raw
List pgsql-admin
Hello,

yesterday, in the process of bloat control, our maintenance script decided to do a vacuum full on a table, because there was more than 50% free space / dead records due to a massive update.

The table normally takes about 20minutes to do a vacuum full (int he last couple of months we already did this 2 times), but this time it took over 8hours, while the table did not grow significantly.

Does anyone has an idea what could have triggered the vacuum go this slow?

wkr,
Bert

--
Bert Desmet

pgsql-admin by date:

Previous
From: raghu ram
Date:
Subject: Re: Question about DB stats resets
Next
From: Manish Kediyal
Date:
Subject: Shell Script for Vacuum