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