Postgres Pro
Downloads
Home   >   mailing lists

[GENERAL] When updating row that has TOAST column, is the TOAST column alsoreinserted ? Or just the oid to the value? - Mailing list pgsql-general

From Dorian Hoxha
Subject [GENERAL] When updating row that has TOAST column, is the TOAST column alsoreinserted ? Or just the oid to the value?
Date
Msg-id CANsFX07ozgyRx-0kvt_cdFWC0zJHJzifu68sS4xiSW-25DFNdg@mail.gmail.com
Whole thread Raw
Responses Re: [GENERAL] When updating row that has TOAST column, is the TOASTcolumn also reinserted ? Or just the oid to the value?
List pgsql-general
Tree view
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 will update will have an index so I think hot-update won't work in this case ? The same question also when full-page-writes is enabled ?

Using 9.6.

Thank you!

pgsql-general by date:

Previous
From: Torsten Förtsch
Date:
Subject: [GENERAL] is this a known bug in 9.6?
Next
From: VENKTESH GUTTEDAR
Date:
Subject: [GENERAL] Appending to multidimentional array.