Postgres Pro
Downloads
Home   >   mailing lists

Re: Wrong plan sequential scan instead of an index one - Mailing list pgsql-performance

From Claus Guttesen
Subject Re: Wrong plan sequential scan instead of an index one
Date
Msg-id b41c75520703300251oe916648r75c16c1bf70cd10@mail.gmail.com
Whole thread Raw
In response to Wrong plan sequential scan instead of an index one  (Gaetano Mendola <mendola@bigfoot.com>)
Responses Re: Wrong plan sequential scan instead of an index one  (Gaetano Mendola <mendola@bigfoot.com>)
List pgsql-performance
Tree view 
> 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

pgsql-performance by date:

Previous
From: Gaetano Mendola
Date:
Subject: Wrong plan sequential scan instead of an index one
Next
From: Richard Huxton
Date:
Subject: Re: Wrong plan sequential scan instead of an index one