[postgis-tickets] r15267 - Cost on ST_SetSRID is preventing index use with relation functions. Change from 10 to 1.

Regina Obe lr at pcorp.us
Sat Dec 3 12:36:47 PST 2016


Author: robe
Date: 2016-12-03 12:36:47 -0800 (Sat, 03 Dec 2016)
New Revision: 15267

Modified:
   trunk/postgis/postgis.sql.in
Log:
Cost on ST_SetSRID is preventing index use with relation functions. Change from 10 to 1.
References #3675 for PostGIS 2.4

Modified: trunk/postgis/postgis.sql.in
===================================================================
--- trunk/postgis/postgis.sql.in	2016-12-02 08:06:09 UTC (rev 15266)
+++ trunk/postgis/postgis.sql.in	2016-12-03 20:36:47 UTC (rev 15267)
@@ -2746,7 +2746,7 @@
 	RETURNS geometry
 	AS 'MODULE_PATHNAME','LWGEOM_set_srid'
 	LANGUAGE 'c' IMMUTABLE STRICT _PARALLEL
-	COST 10;
+	COST 1;
 
 CREATE OR REPLACE FUNCTION ST_SRID(geometry)
 	RETURNS int4



More information about the postgis-tickets mailing list