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

[Alexander W. Rolek]

Paul -

I already have GIST indexes on both tables:

CREATE INDEX layers_geom_4326
  ON gis.layers
  USING gist
  (geom_4326);

CREATE INDEX parcels_geom_4326
  ON gis.parcels
  USING gist
  (geom_4326);

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

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>