Re: b-tree index performance

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 12/15/06 07:50, Martijn van Oosterhout wrote:
> On Fri, Dec 15, 2006 at 07:44:16AM -0600, Ron Johnson wrote:
>>> The difference in performence will be determined by the cost of
>>> comparison. The cost of comparing strings is much higher than for
>>> integers, so it will be slower.
>> And comparing INT8 is more expensive on a 32-bit system.
>
> The difference between int4 and int8 is probably negligable.

Probably compiler-dependent...

>> Since TEXT is totally variable, is there a big difference in TEXT vs
>> CHAR(8)?
>
> Nothing measurable I'd think. It's probably the same code.
>
> Have a nice day,

- --
Ron Johnson, Jr.
Jefferson LA USA

Is "common sense" really valid?
For example, it is "common sense" to white-power racists that
whites are superior to blacks, and that those with brown skins
are mud people.
However, that "common sense" is obviously wrong.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFFgq6KS9HxQb37XmcRAlE6AJ9LxzCHq95wggefa0Q4a6/sBAw7aACgyasp
t8qCwkdarDlhc2N8PKkprrY=
=BBBp
-----END PGP SIGNATURE-----