Index: openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.7.0d2-5.7.0d3.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.7.0d2-5.7.0d3.sql,v diff -u -r1.2 -r1.3 --- openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.7.0d2-5.7.0d3.sql 24 Nov 2010 18:58:45 -0000 1.2 +++ openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.7.0d2-5.7.0d3.sql 27 Mar 2018 12:22:17 -0000 1.3 @@ -6,9 +6,9 @@ -- @cvs-id $Id$ -- --- Avoiding the usage of the coalesce function +-- Avoiding the usage of the coalesce function -- on the site_nodes columns in the where clause --- because this leads to usage of a sequencial scan, +-- because this leads to usage of a sequential scan, -- instead we enforce the usage of an index scan -- by issolating the case on which we need to compare null values -- and using the equal operator.