Index: openacs-4/packages/acs-content-repository/sql/postgresql/upgrade/upgrade-5.9.1d22-5.9.1d23.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/upgrade/upgrade-5.9.1d22-5.9.1d23.sql,v diff -u -N -r1.1.2.1 -r1.1.2.2 --- openacs-4/packages/acs-content-repository/sql/postgresql/upgrade/upgrade-5.9.1d22-5.9.1d23.sql 27 Nov 2016 10:10:37 -0000 1.1.2.1 +++ openacs-4/packages/acs-content-repository/sql/postgresql/upgrade/upgrade-5.9.1d22-5.9.1d23.sql 28 Nov 2016 19:53:23 -0000 1.1.2.2 @@ -2,9 +2,9 @@ -- Reduced generation of dead tuples in postgres. -- -- Background: In the old version, the fields latest and live --- revisions were updated always via two separate dmlDML statements. --- Every update causes in PostgreSQL (tested to pg 9.6) one more dead --- tuple, such that on busy systems, we see 30k + dead tuples per +-- revisions were updated always via two separate DML statements. +-- Every update causes in PostgreSQL (tested against pg 9.6) one more +-- dead tuple, such that on busy systems, we see 30k + dead tuples per -- hour. These dead tuples in turn cause more auto vacuum operations -- and can lead to abandoned query plans. --