[postgis-tickets] r15268 - 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:39:18 PST 2016


Author: robe
Date: 2016-12-03 12:39:18 -0800 (Sat, 03 Dec 2016)
New Revision: 15268

Modified:
   branches/2.3/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.3

Modified: branches/2.3/postgis/postgis.sql.in
===================================================================
--- branches/2.3/postgis/postgis.sql.in	2016-12-03 20:36:47 UTC (rev 15267)
+++ branches/2.3/postgis/postgis.sql.in	2016-12-03 20:39:18 UTC (rev 15268)
@@ -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