On Mon, Jan 24, 2005 at 16:34:09 -0000,
Martin Schäfer <Martin(dot)Schaefer(at)cadcorp(dot)com> wrote:
>
> I'm using the PostGIS spatial extension. Some of my spatial queries (like
> live zooming and panning) should only be performed when the column
> containing the spatial data is spatially indexed, otherwise the first query
> takes almost forever and users will just kill the application out of
> frustration.
If the real problem is long running queries, maybe using a statement timeout
will solve your problem?