From 7777478a20526f5daebaa1c247c5a5de846cc690 Mon Sep 17 00:00:00 2001 From: Regina Obe Date: Sat, 3 Dec 2016 20:36:47 +0000 Subject: [PATCH] Cost on ST_SetSRID is preventing index use with relation functions. Change from 10 to 1. References #3675 for PostGIS 2.4 git-svn-id: http://svn.osgeo.org/postgis/trunk@15267 b70326c6-7e19-0410-871a-916f4a2858ee --- postgis/postgis.sql.in | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/postgis/postgis.sql.in b/postgis/postgis.sql.in index 3df912efb..2a8114bf1 100644 --- a/postgis/postgis.sql.in +++ b/postgis/postgis.sql.in @@ -2746,7 +2746,7 @@ CREATE OR REPLACE FUNCTION ST_SetSRID(geometry,int4) 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 -- 2.50.1