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
);