Message-ID: <427E3D44.4080503@arbash-meinel.com>
Date: Sun, 08 May 2005 11:24:36 -0500
From: John A Meinel <john@arbash-meinel.com>
User-Agent: Mozilla Thunderbird 1.0.2-1.3.2 (X11/20050324)
MIME-Version: 1.0
To: Jeroen van Iddekinge <iddekingej@lycos.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: sequence scan on PK
References: <427E2941.9070105@lycos.com> <427E17BC.7050407@arbash-meinel.com>
	<427E5130.7020702@lycos.com>
In-Reply-To: <427E5130.7020702@lycos.com>
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature";
	boundary="------------enig54424BC0B47EE0772AF1F676"

This is an OpenPGP/MIME signed message (RFC 2440 and 3156)
--------------enig54424BC0B47EE0772AF1F676
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Jeroen van Iddekinge wrote:
>
>>
>> You could tweak with several settings to get it to do an index scan
>> earlier, but these would probably break other queries. You don't need to
>> tune for 100 rows, morelike 100k or 100M.
>
>
> Thanks for respone.
> The index scan was a little bit faster for id=1 and faster for id=99.
>
> Which settings shoud I change for this?  cpu_index_tuple_cost ,
> cpu_operator_cost, cpu_tuple_cost?
>
>
> Jer.

Well, I would start with *don't*. You are only looking at one query,
which is pretty much fast already, and probably is not going to be the
bottleneck. You are optimizing the wrong thing.

That being said, because you have everything cached in ram (since it is
a tiny table), you probably would set random_page_cost = 2.

In theory it should really never be lower than 2, though if you are
trying to force an index scan you can do it.

John
=:->


--------------enig54424BC0B47EE0772AF1F676
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)
Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org

iD8DBQFCfj1HJdeBCYSNAAMRAkUHAJ9jusMa60Ju+Mg4g5OcAaYqVuZLdgCfbftl
LcIWwQ7oQGtjG0ThSLqvVsg=
=9AY8
-----END PGP SIGNATURE-----

--------------enig54424BC0B47EE0772AF1F676--