-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 10/18/06 09:47, Merlin Moncure wrote: > On 10/18/06, Ron Johnson <ron.l.johnson@xxxxxxx> wrote: >> > I tested binary quite a bit and only found it to be a win if moving >> > blobs in and out of the database. On 'normal' tables of mixed fields >> > types of small size, it can actually be slower. Binary is a bit >> > faster for native types and bytea, and slower for character types. >> >> "native types"? > > types operated on directly by the processor. int2, int4, int8, float4, > and float8, and their various aliases :). > > in short, i think using binary for anything other than bytea is a > waste of effort/time, except for bytea. That's counter-intuitive, since you'd (well, I'd) think that doing a binary copy would be faster since the code would bypass the int-to- ascii conversion. - -- 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.5 (GNU/Linux) iD8DBQFFNkRyS9HxQb37XmcRAn4tAJ4xRFmA/T82/iFi4O+sfvBGk4Y+EgCfVjn0 CFs2nT9w6RxTj8dV5C4kBUk= =2RRX -----END PGP SIGNATURE-----
