Postgres Pro
Downloads
Home   >   mailing lists

Re: ALTER TABLE and vacuum - Mailing list pgsql-general

From Vik Fearing
Subject Re: ALTER TABLE and vacuum
Date
Msg-id 57553BF2.3000002@2ndquadrant.fr
Whole thread Raw
In response to ALTER TABLE and vacuum  (Rick Widmer <pgsql@rickwidmer.com>)
List pgsql-general
Tree view 
On 06/06/16 10:55, Rick Widmer wrote:
> Do I need to vacuum after an alter table command?

If the specific command you do rewrites the table, you absolutely should
vacuum in order to restore the visibility map.  Otherwise, it not necessary.

> Does it matter if there is a default or if we accept NULLs for the new
> field?

Yes, that makes a difference.  If you add a column that defaults to
NULL, the table will not be rewritten.
--
Vik Fearing                                          +33 6 46 75 15 36
http://2ndQuadrant.fr     PostgreSQL : Expertise, Formation et Support

pgsql-general by date:

Previous
From: Rick Widmer
Date:
Subject: ALTER TABLE and vacuum
Next
From: Sridhar N Bamandlapally
Date:
Subject: OUT parameter and RETURN table/setof