[postgis-users] Spatial indexes

[Markus Schaber]

Hi, James,

James Rutter wrote:
> I’ve created a view on a spatial table and added a line into the
> geometry_columns table to reference the view. The problem I’ve got is
> trying to pass on to the client (in my case Cadcorp GIS system)
> information about a spatial index. I know that a view is essentially an
> ‘on the fly’ reconstruction of a query on a table but is there any way
> to associate a spatial index with a view?

This is not really a PostGIS problem, but a general PostgreSQL problem.

Currently, PostgreSQL cannot create indices on views. However, it will
happily use indices on the underlying tables whenever it thinks they can
help to accelerate the query.

Maybe you can create such indices (possibly functional ones)?

You could give us more details about your view and the queries typically
runing against it, so we could help more.

HTH,
Markus
-- 
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in Europe! www.ffii.org
www.nosoftwarepatents.org