Home > mailing lists

Re: Forcing query to use an index - Mailing list pgsql-sql

From	Josh Berkus
Subject	Re: Forcing query to use an index
Date	March 3, 2003 20:37:30
Msg-id	200303031409.04345.josh@agliodbs.com Whole thread Raw
In response to	Forcing query to use an index (Michael Nachbaur <mike@nachbaur.com>)
Responses	Re: Forcing query to use an index (Michael Nachbaur <mike@nachbaur.com>)
List	pgsql-sql

Tree view

Michael,

> Unfortunately one stage in the query keeps using a sequence scan rather
> than the index.  Here is the "EXPLAIN ANALYZE" results for the 115 line
> SQL query.

If you want any help, you'll need to post the query as well as the explain
results.


--
-Josh BerkusAglio Database SolutionsSan Francisco

pgsql-sql by date:

From: Greg Stark
Date: 03 March 2003, 19:47:50
Subject: Gist indexes on int arrays

From: Stephan Szabo
Date: 03 March 2003, 20:38:28
Subject: Re: Forcing query to use an index

Re: Forcing query to use an index - Mailing list pgsql-sql

Previous

Next