[postgis-users] Spatial indexes

[Markus Schaber]

Hi, Martin,

Martin Daly wrote:

>> You could give us more details about your view and the 
>> queries typically runing against it, so we could help more.
> 
> James' problem is not creating or using indices, but detecting them.
> SIS cannot discover whether or not a geometry column in a view has a
> spatial index.  SIS can do this with a table using standard PostgreSQL
> metadata, but not with a view.

Ah, I understand. Sorry for the confusion I added.

> SIS, when it encounters a table with a non-spatially-indexed geometry
> column, or a view where it cannot detect the spatial index, presents
> users with restricted connection options, to avoid, for example,
> unexpectedly long redraw times when zoomed in on a large dataset.
> 
> As you point out, this is a PostgreSQL problem rather then a PostGIS
> one.

Sounds rather like an SIS prolem now. :-)

Regards,
Markus