[postgis-tickets] r15536 - Mark all raster aggregates as parallel safe.

[Regina Obe]

Author: robe
Date: 2017-08-06 22:09:02 -0700 (Sun, 06 Aug 2017)
New Revision: 15536

Modified:
   trunk/raster/rt_pg/rtpostgis.sql.in
Log:
Mark all raster aggregates as parallel safe.

Modified: trunk/raster/rt_pg/rtpostgis.sql.in
===================================================================
--- trunk/raster/rt_pg/rtpostgis.sql.in	2017-08-06 21:37:17 UTC (rev 15535)
+++ trunk/raster/rt_pg/rtpostgis.sql.in	2017-08-07 05:09:02 UTC (rev 15536)
@@ -521,9 +521,13 @@
 	LANGUAGE 'c' IMMUTABLE _PARALLEL;
 
 -- Availability: 2.2.0
+-- Changed: 2.4.0 marked parallel safe
 CREATE AGGREGATE st_summarystatsagg(raster, integer, boolean, double precision) (
 	SFUNC = _st_summarystats_transfn,
 	STYPE = internal,
+#if POSTGIS_PGSQL_VERSION >= 96
+	parallel = safe,
+#endif
 	FINALFUNC = _st_summarystats_finalfn
 );
 
@@ -536,9 +540,13 @@
 	LANGUAGE 'c' IMMUTABLE _PARALLEL;
 
 -- Availability: 2.2.0
+-- Changed: 2.4.0 marked parallel safe
 CREATE AGGREGATE st_summarystatsagg(raster, boolean, double precision) (
 	SFUNC = _st_summarystats_transfn,
 	STYPE = internal,
+#if POSTGIS_PGSQL_VERSION >= 96
+	parallel = safe,
+#endif
 	FINALFUNC = _st_summarystats_finalfn
 );
 
@@ -551,9 +559,13 @@
 	LANGUAGE 'c' IMMUTABLE _PARALLEL;
 
 -- Availability: 2.2.0
+-- Changed: 2.4.0 marked parallel safe
 CREATE AGGREGATE st_summarystatsagg(raster, int, boolean) (
 	SFUNC = _st_summarystats_transfn,
 	STYPE = internal,
+#if POSTGIS_PGSQL_VERSION >= 96
+	parallel = safe,
+#endif
 	FINALFUNC = _st_summarystats_finalfn
 );
 
@@ -593,7 +605,7 @@
 )
 	RETURNS summarystats
 	AS $$ SELECT @extschema at ._ST_summarystats($1, $2, $3, $4, 1) $$
-	LANGUAGE 'sql' STABLE STRICT;
+	LANGUAGE 'sql' STABLE STRICT _PARALLEL;
 
 CREATE OR REPLACE FUNCTION st_summarystats(
 	rastertable text,
@@ -602,7 +614,7 @@
 )
 	RETURNS summarystats
 	AS $$ SELECT @extschema at ._ST_summarystats($1, $2, 1, $3, 1) $$
-	LANGUAGE 'sql' STABLE STRICT;
+	LANGUAGE 'sql' STABLE STRICT _PARALLEL;
 
 CREATE OR REPLACE FUNCTION st_approxsummarystats(
 	rastertable text,
@@ -613,7 +625,7 @@
 )
 	RETURNS summarystats
 	AS $$ SELECT @extschema at ._ST_summarystats($1, $2, $3, $4, $5) $$
-	LANGUAGE 'sql' STABLE STRICT;
+	LANGUAGE 'sql' STABLE STRICT _PARALLEL;
 
 CREATE OR REPLACE FUNCTION st_approxsummarystats(
 	rastertable text,
@@ -623,7 +635,7 @@
 )
 	RETURNS summarystats
 	AS $$ SELECT @extschema at ._ST_summarystats($1, $2, $3, TRUE, $4) $$
-	LANGUAGE 'sql' STABLE STRICT;
+	LANGUAGE 'sql' STABLE STRICT _PARALLEL;
 
 CREATE OR REPLACE FUNCTION st_approxsummarystats(
 	rastertable text,
@@ -632,7 +644,7 @@
 )
 	RETURNS summarystats
 	AS $$ SELECT @extschema at ._ST_summarystats($1, $2, 1, $3, 0.1) $$
-	LANGUAGE 'sql' STABLE STRICT;
+	LANGUAGE 'sql' STABLE STRICT _PARALLEL;
 
 CREATE OR REPLACE FUNCTION st_approxsummarystats(
 	rastertable text,
@@ -641,7 +653,7 @@
 )
 	RETURNS summarystats
 	AS $$ SELECT @extschema at ._ST_summarystats($1, $2, 1, TRUE, $3) $$
-	LANGUAGE 'sql' STABLE STRICT;
+	LANGUAGE 'sql' STABLE STRICT _PARALLEL;
 
 -----------------------------------------------------------------------
 -- ST_Count and ST_ApproxCount
@@ -797,6 +809,9 @@
 CREATE AGGREGATE st_countagg(raster, integer, boolean, double precision) (
 	SFUNC = _st_countagg_transfn,
 	STYPE = agg_count,
+#if POSTGIS_PGSQL_VERSION >= 96
+	parallel = safe,
+#endif
 	FINALFUNC = _st_countagg_finalfn
 );
 
@@ -824,6 +839,9 @@
 CREATE AGGREGATE st_countagg(raster, integer, boolean) (
 	SFUNC = _st_countagg_transfn,
 	STYPE = agg_count,
+#if POSTGIS_PGSQL_VERSION >= 96
+	parallel = safe,
+#endif
 	FINALFUNC = _st_countagg_finalfn
 );
 
@@ -852,6 +870,9 @@
 CREATE AGGREGATE st_countagg(raster, boolean) (
 	SFUNC = _st_countagg_transfn,
 	STYPE = agg_count,
+#if POSTGIS_PGSQL_VERSION >= 96
+	parallel = safe,
+#endif
 	FINALFUNC = _st_countagg_finalfn
 );
 
@@ -5974,9 +5995,13 @@
 	LANGUAGE 'sql' IMMUTABLE STRICT _PARALLEL;
 
 -- Availability: 2.1.0
+-- Changed: 2.4.0 marked parallel safe
 CREATE AGGREGATE st_samealignment(raster) (
 	SFUNC = _st_samealignment_transfn,
 	STYPE = agg_samealignment,
+#if POSTGIS_PGSQL_VERSION >= 96
+	parallel = safe,
+#endif
 	FINALFUNC = _st_samealignment_finalfn
 );