Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
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.
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).
