On Thu, Sep 23, 2010 at 10:26 AM, Dmitry Teslenko <[email protected]> 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
