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 ?