On Thu, Sep 23, 2010 at 10:26 AM, Dmitry Teslenko <dteslenko@xxxxxxxxx> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
