Bob Pawley <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings