Re: Adding a column - Mailing list pgsql-general

From Tom Lane
Subject Re: Adding a column
Date
Msg-id 28686.1162143728@sss.pgh.pa.us
Whole thread Raw
In response to Adding a column  (Bob Pawley <rjpawley@shaw.ca>)
List pgsql-general
Bob Pawley <rjpawley@shaw.ca> writes:
> Any thoughts on why dynamically adding a column to a table would require =
> a run time of 24,000 + milliseconds??

Updating all the rows to store the default value, no doubt.  See
http://developer.postgresql.org/pgdocs/postgres/ddl-alter.html
especially the tip under 5.5.1.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: arrays of user types.
Next
From: Alvaro Herrera
Date:
Subject: Re: Modifying SQL parser with extensions?