3 ms·
As I know, not every updates rewrite indexes in PG. It has single page clean up and HOT (heap only tuple) update optimization. Please refer to 64~ page of http
by dialogbox 10y ago
As I know, not every updates rewrite indexes in PG. It has single page clean up and HOT (heap only tuple) update optimization.
Please refer to 64~ page of https://momjian.us/main/writings/pgsql/mvcc.pdf https://momjian.us/main/writings/pgsql/mvcc.pdf.