3 ms·
Thank you for introducing me to "heap only tuples", I did not know about it. From what I read about it from Postgres's documentation[0], it would have helped in
by pritambaral 10y ago
Thank you for introducing me to "heap only tuples", I did not know about it. From what I read about it from Postgres's documentation[0], it would have helped in the updates where no indexed column was updated.
0: https://wiki.postgresql.org/wiki/Index-only_scans#Interaction_with_HOT https://wiki.postgresql.org/wiki/Index-only_scans#Interactio...
- dialogbox 10y agoYou can find more detailed explanation from Bruce Momjian's site. (From page 64: https://momjian.us/main/writings/pgsql/mvcc.pdf https://momjian.us/main/writings/pgsql/mvcc.pdf)