Horton

Re: Happy column adding (was RE: [HACKERS] Happy column dropping)

Don Baccus <dhogaza@pacifier.com>

View thread
From: Don Baccus <dhogaza@pacifier.com>
To: Tom Lane <tgl@sss.pgh.pa.us>, "Hiroshi Inoue" <Inoue@tpf.co.jp>
Cc: "Peter Eisentraut" <peter_e@gmx.net>, "PostgreSQL Development" <pgsql-hackers@postgreSQL.org>
Date: 2000-01-25T19:03:15Z
Lists: pgsql-hackers 
At 12:23 PM 1/25/00 -0500, Tom Lane wrote:

>The only way to make that happen is for ADD COLUMN to switch over to
>an implementation that rewrites all the tuples.  Which I think is the
>right way to go ... but per this discussion, it's not a trivial fix.

Might it be possible to keep the current (ummm) hack for simple
add column name type and only rewrite for fancy cases?  The current
implementation is awfully fast and there's the advantage of not
needing sufficient disk storage to duplicate the table.





- Don Baccus, Portland OR <dhogaza@pacifier.com>
  Nature photos, on-line guides, Pacific Northwest
  Rare Bird Alert Service and other goodies at
  http://donb.photo.net.