Re: alter table set TABLE ACCESS METHOD
От
Jeff Davis
Тема
Re: alter table set TABLE ACCESS METHOD
Дата
Msg-id
3bee08c2ca0fab15d14899afcb19490f29e0ec6f.camel@j-davis.com
Ответ на
Re: alter table set TABLE ACCESS METHOD (Justin Pryzby)
Список
Дерево обсуждения
Re: alter table set TABLE ACCESS METHOD Jeff Davis <pgsql@j-davis.com>
Re: alter table set TABLE ACCESS METHOD Justin Pryzby <pryzby@telsasoft.com>
Re: alter table set TABLE ACCESS METHOD Jeff Davis <pgsql@j-davis.com>
Re: alter table set TABLE ACCESS METHOD Jeff Davis <pgsql@j-davis.com>
Re: alter table set TABLE ACCESS METHOD Jeff Davis <pgsql@j-davis.com>
Re: alter table set TABLE ACCESS METHOD Michael Paquier <michael@paquier.xyz>
Re: alter table set TABLE ACCESS METHOD Justin Pryzby <pryzby@telsasoft.com>
Re: alter table set TABLE ACCESS METHOD Jeff Davis <pgsql@j-davis.com>
Re: alter table set TABLE ACCESS METHOD vignesh C <vignesh21@gmail.com>
Re: alter table set TABLE ACCESS METHOD Zhihong Yu <zyu@yugabyte.com>
Re: alter table set TABLE ACCESS METHOD Justin Pryzby <pryzby@telsasoft.com>
Re: alter table set TABLE ACCESS METHOD Michael Paquier <michael@paquier.xyz>
Re: alter table set TABLE ACCESS METHOD Michael Paquier <michael@paquier.xyz>
Re: alter table set TABLE ACCESS METHOD Jeff Davis <pgsql@j-davis.com>
Re: alter table set TABLE ACCESS METHOD Michael Paquier <michael@paquier.xyz>
Re: alter table set TABLE ACCESS METHOD Jeff Davis <pgsql@j-davis.com>
Re: alter table set TABLE ACCESS METHOD Michael Paquier <michael@paquier.xyz>
On Thu, 2021-05-06 at 17:19 -0500, Justin Pryzby wrote: > If ATRewriteTable didn't > handle this, > data would become inaccessible if an AM failed to de-toast tuples. If the AM fails to detoast tuples, it's got bigger problems than ALTER TABLE. What about INSERT INTO ... SELECT? It's the table AM's responsibility to detoast out-of-line datums and toast any values that are too large (see heapam.c:heap_prepare_insert()). Regards, Jeff Davis
В списке pgsql-hackers по дате отправления
От: Chapman Flack
Дата:
