This is a post I put on the potgres performance list. They suggested I
take it up on the PostGis list
Postgres versions 9.5.4 and 9.6.0 running on Windows Server 2012.
Installed using EnterpriseDB. Both instances are on the same server,
postgresql.conf for both are the same except max_locks_p
_Contains
That should force the index to kick in.
-Original Message-
From: postgis-users [mailto:postgis-users-boun...@lists.osgeo.org] On Behalf Of
Bill Measday
Sent: Thursday, December 01, 2016 7:47 PM
To: postgis-users@lists.osgeo.org
Subject: [postgis-users] Substantial different
scan. I assume I'm misunderstanding your
suggestion.
Rgds
Bill
On 2/12/2016 5:29 PM, Bill Measday wrote:
Thanks Regina,
First, your first suggestion didn't seem to achieve anything - even
the costs in the explain remained the same (1e10).
Second, you lost me a little w
Thanks Regina - nice to know it wasn't just my incompetence!.
Good luck tracking down the root cause.
Rgds
Bill
On 4/12/2016 6:53 AM, Regina Obe wrote:
For reference I have ticketed this as:
https://trac.osgeo.org/postgis/ticket/3675
-- message --
Bill,
Never mind.
t_setsrid(
geometry,
integer)
RETURNS geometry AS
'$libdir/postgis-2.3', 'LWGEOM_set_srid'
LANGUAGE c IMMUTABLE STRICT PARALLEL SAFE
COST 1;
*From:*postgis-users [mailto:postgis-users-boun...@lists.osgeo.org]
*On Behalf Of *Bill Measday
*Sent:* Saturday, December 03, 20
Just checking that someone was paying attention [cough]
Thanks - that explains it.
Bill
On 4/12/2016 9:17 PM, Sandro Santilli wrote:
On Sun, Dec 04, 2016 at 02:46:03PM +1100, Bill Measday wrote:
This looks odd. Here is what pgAdmin tells me if is the current definition
of st_setsrid (cost of