Re: Re: New server to improve performance on our large and busy DB - advice? (v2)

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Ivan Voras <ivoras(at)freebsd(dot)org>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Re: New server to improve performance on our large and busy DB - advice? (v2)
Date: 2010-01-15 14:41:55
Message-ID: 603c8f071001150641p696411f0o4360c7068221fa23@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Fri, Jan 15, 2010 at 8:43 AM, Ivan Voras <ivoras(at)freebsd(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Fernando Hevia 2010-01-15 15:49:00 Re: new server I/O setup
Previous Message Ivan Voras 2010-01-15 13:43:10 Re: New server to improve performance on our large and busy DB - advice? (v2)