[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