Re: [GENERAL] When updating row that has TOAST column, is the TOAST column also reinserted ? Or just the oid to the value?

Albe Laurenz writes: > Dorian Hoxha wrote: >> When updating row that has TOAST column, is the TOAST column also inserted ? >> Or just the oid? > The TOAST table will remain unchanged by the UPDATE; you can see that with the > "pageinspect" contrib module: You can also read the documentation ;-)

Re: [GENERAL] When updating row that has TOAST column, is the TOAST column also reinserted ? Or just the oid to the value?

Great info Albe! On 13/12/2016 16:20, Albe Laurenz wrote: Dorian Hoxha wrote: When updating row that has TOAST column, is the TOAST column also inserted ? Or just the oid? Say I have a 1MB value in the TOAST column, and I update the row by changing another column, and since every update is a

Re: [GENERAL] When updating row that has TOAST column, is the TOAST column also reinserted ? Or just the oid to the value?

Dorian Hoxha wrote: > When updating row that has TOAST column, is the TOAST column also inserted ? > Or just the oid? > > Say I have a 1MB value in the TOAST column, and I update the row by changing > another column, and since > every update is an insert, will it also reinsert the toast-column ?

[GENERAL] When updating row that has TOAST column, is the TOAST column also reinserted ? Or just the oid to the value?

Hello friends, When updating row that has TOAST column, is the TOAST column also inserted ? Or just the oid? Say I have a 1MB value in the TOAST column, and I update the row by changing another column, and since every update is an insert, will it also reinsert the toast-column ? The column that I