[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