Re: [GENERAL] ALTER TABLE and vacuum

2016-06-06 Thread Vik Fearing
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 NU

[GENERAL] ALTER TABLE and vacuum

2016-06-06 Thread Rick Widmer
Do I need to vacuum after an alter table command? Does it matter if there is a default or if we accept NULLs for the new field? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general