Re: insertion of bytea - Mailing list pgsql-performance

From Chris Mair
Subject Re: insertion of bytea
Date
Msg-id 19131.82.58.59.118.1130276507.squirrel@www.endian.it
Whole thread Raw
In response to Re: insertion of bytea  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
>> Am I correct in assuming that even though I'm passing my 52000
>> bytes as a (char *) to PQexecPrepared(), encoding/decoding is
>> happening (think 0 -> \000) somewhere in the transfer?
>
> Are you specifying it as a text or binary parameter?  Have you looked to
> see if the stored data is what you expect?

I'm specifying it as binary (i.e. one's in PQexecPrepared's
format parameter). The stored data is correct.

I'll try "copy from stdin with binary" tomorrow and see what
I get...

Thanks & Bye, Chris.



pgsql-performance by date:

Previous
From: "Chris Mair"
Date:
Subject: Re: insertion of bytea
Next
From: Tom Lane
Date:
Subject: Re: Outer join query plans and performance