I changed the type of a column from varchar to uuid in a table with a couple of million rows. This caused quite an extensive autovacuum.

Can somebody explain why this is required and should I have done a vacuum full?

I am working with Postges 13.8.

1 Answer 1


If you change the type with

ALTER TABLE tab ALTER col TYPE uuid USING col::uuid;

that will not trigger an autovacuum run. I guess that it was a coincidence that autovacuum launched a worker on the table.

Don't run VACUUM (FULL).

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.