Postgres Pro
Downloads
Home   >   mailing lists

Re: How to find out programmatically whether a query on a view will use an index? - Mailing list pgsql-sql

From Bruno Wolff III
Subject Re: How to find out programmatically whether a query on a view will use an index?
Date
Msg-id 20050125174023.GA13418@wolff.to
Whole thread Raw
In response to How to find out programmatically whether a query on a view will use an index?  (Martin Schäfer <Martin.Schaefer@cadcorp.com>)
List pgsql-sql
Tree view 
On Mon, Jan 24, 2005 at 16:34:09 -0000, Martin Schäfer <Martin.Schaefer@cadcorp.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?

pgsql-sql by date:

Previous
From: Thomas Chille
Date:
Subject: difficult JOIN
Next
From: zeus@ix.netcom.com
Date:
Subject: Re: "How do I ..." SQL question