Re: COPY FROM STDIN instead of INSERT - Mailing list pgsql-general

From Merlin Moncure
Subject Re: COPY FROM STDIN instead of INSERT
Date
Msg-id b42b73150610180747o277727d5idedd88d6979745bf@mail.gmail.com
Whole thread Raw
In response to Re: COPY FROM STDIN instead of INSERT  (Ron Johnson <ron.l.johnson@cox.net>)
Responses Re: COPY FROM STDIN instead of INSERT  (Ron Johnson <ron.l.johnson@cox.net>)
List pgsql-general
On 10/18/06, Ron Johnson <ron.l.johnson@cox.net> 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

pgsql-general by date:

Previous
From: Ron Johnson
Date:
Subject: Re: COPY FROM STDIN instead of INSERT
Next
From: Brad Nicholson
Date:
Subject: Stats Collector Won't Start