Postgres Pro
Downloads
Home   >   mailing lists

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

From Robert Haas
Subject Re: Re: New server to improve performance on our large and busy DB - advice? (v2)
Date
Msg-id 603c8f071001150641p696411f0o4360c7068221fa23@mail.gmail.com
Whole thread Raw
In response to Re: New server to improve performance on our large and busy DB - advice? (v2)  (Ivan Voras <ivoras@freebsd.org>)
List pgsql-performance
Tree view 
On Fri, Jan 15, 2010 at 8:43 AM, Ivan Voras <ivoras@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

pgsql-performance by date:

Previous
From: Ivan Voras
Date:
Subject: Re: New server to improve performance on our large and busy DB - advice? (v2)
Next
From: "Ing. Marcos L. Ortiz Valmaseda"
Date:
Subject: Re: Re: New server to improve performance on our large and busy DB - advice? (v2)