Postgres Pro
Downloads
Home   >   mailing lists

Re: Forcing using index instead of sequential scan? - Mailing list pgsql-performance

From Peter Eisentraut
Subject Re: Forcing using index instead of sequential scan?
Date
Msg-id 200607211345.41573.peter_e@gmx.net
Whole thread Raw
In response to Forcing using index instead of sequential scan?  (<robin.c.smith@bt.com>)
List pgsql-performance
Tree view 
robin.c.smith@bt.com wrote:
> What is the best way to force the use of indexes in these queries?

Well, the brute-force method is to use SET enable_seqscan TO off, but if
you want to get to the bottom of this, you should look at or post the
EXPLAIN ANALYZE output of the offending queries.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

pgsql-performance by date:

Previous
From:
Date:
Subject: Re: Forcing using index instead of sequential scan?
Next
From: "Petronenko D.S."
Date:
Subject: postgres benchmarks