X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 710AB3A57B9 for ; Tue, 25 Jan 2005 17:26:12 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 90290-09 for ; Tue, 25 Jan 2005 17:26:08 +0000 (GMT) Received: from wolff.to (wolff.to [66.93.249.74]) by svr1.postgresql.org (Postfix) with SMTP id D1BF93A5738 for ; Tue, 25 Jan 2005 17:26:06 +0000 (GMT) Received: (qmail 14012 invoked by uid 500); 25 Jan 2005 17:40:23 -0000 Date: Tue, 25 Jan 2005 11:40:23 -0600 From: Bruno Wolff III To: Martin =?iso-8859-1?Q?Sch=E4fer?= Cc: pgsql-sql@postgresql.org Subject: Re: How to find out programmatically whether a query on a view will use an index? Message-ID: <20050125174023.GA13418@wolff.to> Mail-Followup-To: Martin =?iso-8859-1?Q?Sch=E4fer?= , pgsql-sql@postgresql.org References: <37936EEC582B394A9E1AA951991A551609D274@dev001_pdc.Dev.cadcorp.net> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <37936EEC582B394A9E1AA951991A551609D274@dev001_pdc.Dev.cadcorp.net> User-Agent: Mutt/1.5.6i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.007 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200501/217 X-Sequence-Number: 20005 On Mon, Jan 24, 2005 at 16:34:09 -0000, Martin Schäfer 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?