Index: openacs-4/packages/acs-content-repository/acs-content-repository.info =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/acs-content-repository.info,v diff -u -r1.109.2.26 -r1.109.2.27 --- openacs-4/packages/acs-content-repository/acs-content-repository.info 27 Nov 2016 10:10:37 -0000 1.109.2.26 +++ openacs-4/packages/acs-content-repository/acs-content-repository.info 28 Nov 2016 19:53:23 -0000 1.109.2.27 @@ -9,7 +9,7 @@ f t - + OpenACS The canonical repository for OpenACS content. 2016-10-24 @@ -21,7 +21,7 @@ GPL 3 - + 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 -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. -- Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/acs-content-repository/sql/postgresql/upgrade/upgrade-5.9.1d23-5.9.1d24.sql'. Fisheye: No comparison available. Pass `N' to diff? Index: openacs-4/packages/acs-content-repository/tcl/revision-procs-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/tcl/revision-procs-postgresql.xql,v diff -u -r1.10.18.3 -r1.10.18.4 --- openacs-4/packages/acs-content-repository/tcl/revision-procs-postgresql.xql 31 Aug 2016 10:55:24 -0000 1.10.18.3 +++ openacs-4/packages/acs-content-repository/tcl/revision-procs-postgresql.xql 28 Nov 2016 19:53:23 -0000 1.10.18.4 @@ -118,18 +118,19 @@ select content_revision__new ( - /* title => */ :title, - /* description => */ :description, - /* publish_date => */ current_timestamp, - /* mime_type => */ :mime_type, - /* nls_language => */ null, - /* data => */ null, - /* item_id => */ :item_id, - /* revision_id => */ :revision_id, - /* creation_date => */ current_timestamp, - /* creation_user => */ :creation_user, - /* creation_ip => */ :creation_ip, - /* package_id => */ :package_id + /* title => */ :title, + /* description => */ :description, + /* publish_date => */ current_timestamp, + /* mime_type => */ :mime_type, + /* nls_language => */ null, + /* data => */ null, + /* item_id => */ :item_id, + /* revision_id => */ :revision_id, + /* creation_date => */ current_timestamp, + /* creation_user => */ :creation_user, + /* creation_ip => */ :creation_ip, + /* content_length => */ null, + /* package_id => */ :package_id );