On Fri, Jan 15, 2010 at 8:43 AM, Ivan Voras <ivoras@xxxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
