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 <rmrodrig...@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@lists.osgeo.org > https://lists.osgeo.org/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users
