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

Re: Wrong plan sequential scan instead of an index one

From: Gaetano Mendola <mendola(at)bigfoot(dot)com>
To: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Cc: Claus Guttesen <kometen(at)gmail(dot)com>
Subject: Re: Wrong plan sequential scan instead of an index one
Date: 2007-03-30 10:08:26
Message-ID: 460CE19A.3060909@bigfoot.com (view raw or flat)
Thread:
Lists: pgsql-performance
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Claus Guttesen wrote:
>> 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?

I have tuned that number already at 2.5, lowering it to 2 doesn't change
the plan.

Regards
Gaetano Mendola
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.5 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFGDOGa7UpzwH2SGd4RAjvaAKDAbz/vxwyOBPCILGpw8rBSvTFMtACfRPBe
yMge0RFfww0ef7xrGBLal7o=
=k+RM
-----END PGP SIGNATURE-----

In response to

Responses

pgsql-performance by date

Next:From: Gaetano MendolaDate: 2007-03-30 10:15:53
Subject: Re: Wrong plan sequential scan instead of an index one
Previous:From: Claus GuttesenDate: 2007-03-30 09:51:03
Subject: Re: Wrong plan sequential scan instead of an index one

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