On 10/18/06, Ron Johnson <[EMAIL PROTECTED]> 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.
merlin
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
