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. merlin
