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

Поиск
Список
Период
Сортировка
От Don Baccus
Тема Re: Happy column adding (was RE: [HACKERS] Happy column dropping)
Дата
Msg-id 3.0.1.32.20000125110315.00f864f0@mail.pacifier.com
обсуждение исходный текст
Ответ на Re: Happy column adding (was RE: [HACKERS] Happy column dropping)  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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
Serviceand other goodies at http://donb.photo.net.
 


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Don Baccus
Дата:
Сообщение: Re: [HACKERS] Happy column dropping
Следующее
От: Don Baccus
Дата:
Сообщение: Re: Happy column adding (was RE: [HACKERS] Happy column dropping)