| From: | Don Baccus <dhogaza(at)pacifier(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)jp> |
| Cc: | "Peter Eisentraut" <peter_e(at)gmx(dot)net>, "PostgreSQL Development" <pgsql-hackers(at)postgreSQL(dot)org> |
| Subject: | Re: Happy column adding (was RE: [HACKERS] Happy column dropping) |
| Date: | 2000-01-25 19:03:15 |
| Message-ID: | 3.0.1.32.20000125110315.00f864f0@mail.pacifier.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| 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(at)pacifier(dot)com>
Nature photos, on-line guides, Pacific Northwest
Rare Bird Alert Service and other goodies at
http://donb.photo.net.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Don Baccus | 2000-01-25 19:05:43 | Re: Happy column adding (was RE: [HACKERS] Happy column dropping) |
| Previous Message | Don Baccus | 2000-01-25 18:55:42 | Re: [HACKERS] Happy column dropping |