Re: Wrong plan sequential scan instead of an index one

From: "Claus Guttesen" <kometen(at)gmail(dot)com>
To: "Gaetano Mendola" <mendola(at)bigfoot(dot)com>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Wrong plan sequential scan instead of an index one
Date: 2007-03-30 09:51:03
Message-ID: b41c75520703300251oe916648r75c16c1bf70cd10@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> Hi all,
> take a look at those plans:

Try changing random_page_cost from the default 4 to 2 in postgresql.conf:

random_page_cost = 2

The default in postgresql is somewhat conservative. This setting
indicates for postgresql how fast your disks are, the lower the
faster.

Could this setting be changed to 2 as default rather than 4?

regards
Claus

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Gaetano Mendola 2007-03-30 10:08:26 Re: Wrong plan sequential scan instead of an index one
Previous Message Richard Huxton 2007-03-30 09:48:12 Re: Wrong plan sequential scan instead of an index one