On Fri, Jan 15, 2010 at 8:43 AM, Ivan Voras <ivo...@freebsd.org> wrote: > Have you tried decreasing random_page_cost in postgresql.conf? Or setting > (as a last resort) enable_seqscan = off?
If you need to set enable_seqscan to off to get the planner to use your index, the chances that that index are actually going to improve performance are extremely poor. ...Robert -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance