[postgis-users] very strange bug generating incorrect ST_Distance calculations

[Paul Ramsey]

Comparing the results of _ST_DistanceTree and _ST_DistanceUnCached is
a good way to tease out whether there are differences between the
implementations without having to fight the caching machinery along
the way.

P.

On Thu, Jan 10, 2019 at 7:00 AM Raúl Marín Rodríguez
<rmrodriguez at carto.com> wrote:
>
> Hi,
>
> In my case I get dist_geography between gid 1 and gid 3 0 in both queries.
>
> This looks like a possible issue around the geos cache, something similar
> to https://trac.osgeo.org/postgis/ticket/4269. Can you run them with
> EXPLAIN ANALYZE?
>
> --
> Raúl Marín Rodríguez
> carto.com
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users