Re: Frequent Update Project: Design Overview of HOTUpdates

Hi,> True, but Nikhil has run tests that clearly show HOT outperforming> current situation in the case of long running
transactions.The need to> optimise HeapTupleSatisfiesVacuum() and avoid long chains does still> remain a difficulty for
bothHOT and the current situation.>
 

Yes, I carried out some pgbench runs comparing our current HOT update
patch with PG82BETA2 sources for the long running transaction case. For
an apples to apples comparison we got roughly 170% improvement with the
HOT update patch over BETA2.

In case of BETA2, since all versions are in the main heap, we end up
doing multiple index scans for them. In case of HOT updates, we have a
single index entry with the chains getting traversed from the overflow
relation. So as Simon has mentioned the need to avoid long chains remains
a difficulty for both the situations.

Regards,
Nikhils