[GENERAL] How much work is it to add/drop columns, really?

Hello there. I read http://www.postgresql.org/docs/current/static/sql-altertable.html and find it interesting that Adding a column with a non-null default or changing the type of an existing column will require the entire table to be rewritten. This might take a significant amount of time for a

Re: [GENERAL] How much work is it to add/drop columns, really?

On Wed, Jan 27, 2010 at 5:45 PM, A B gentosa...@gmail.com wrote: Hello there. I read http://www.postgresql.org/docs/current/static/sql-altertable.html and find it interesting that Adding a column with a non-null default or changing the type of an existing column will require the entire