2 things
First, unfortunately the full query doesn't work as in some cases the
subquery returns more than one row. Not sure why, as the geom should be
a rectangle (more or less given the projection, but was created from 4
points), but maybe right near the boundary there are issues (on
reflec
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 with your second suggestion. As I gather
_st_contains explicitly avoids the index.
Tried
explain SELECT address_default_geocod
Oops minor change we also added PARALLEL SAFE to a good number of functions,
though I don't see how that could cause your issue.
So full def should be below for 9.6
CREATE OR REPLACE FUNCTION _st_contains(geom1 geometry, geom2 geometry) RETURNS
boolean AS '$libdir/postgis-2.3', 'contains'
LANGUA
I have seen this on rare occasions in past but not recently where the planner
doesn't break apart the ST_Contains or ST_Intersects into the component steps.
We made some changes to costing in 2.3.0, but ST_Contains (and _ST_Contains)
wasn't one of them so that doesn't quite explain this.
Couple o
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
Hi,
In order to try backup/restore of production environment, I want to install
PostgreSQL 9.3 / Postgis 2.1 on a fresh Debian Jessie server.
To do that, I add the postgresql repository:
echo "deb http://apt.postgresql.org/pub/repos/apt/ jessie-pgdg main" >
/etc/apt/sources.list.d/pgdg.list
Then
