Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group