On Thu, Sep 23, 2010 at 10:26 AM, Dmitry Teslenko <dteslenko@gmail.com> wrote:
> I know I can set enable_seqscan = off.
> Is there other ways to enforce index usage?
Not really, but I suspect random_page_cost and seq_page_cost might
help the planner make better decisions. Is your data by any chance
mostly cached in memory?
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise Postgres Company