| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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-----
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gaetano Mendola | 2007-03-30 10:15:53 | Re: Wrong plan sequential scan instead of an index one |
| Previous Message | Claus Guttesen | 2007-03-30 09:51:03 | Re: Wrong plan sequential scan instead of an index one |