[postgis-users] Slow ST_Intersects and Materialized Views (EXPLAIN ANALYZE VERBOSE)

Alexander W. Rolek a.rolek at gmail.com
Thu May 28 16:06:10 PDT 2015

Paul -

I already have GIST indexes on both tables:

CREATE INDEX layers_geom_4326
  ON gis.layers
  USING gist

CREATE INDEX parcels_geom_4326
  ON gis.parcels
  USING gist

And from the output it looks like it's doing an "Bitmap index scan on

Is the gist index not being used?

Alexander W. Rolek
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20150528/b51eb1a3/attachment.html>

More information about the postgis-users mailing list