Re: [PERFORM] insertion of bytea

2005-10-27 Thread Chris Mair
> On Tue, Oct 25, 2005 at 03:44:36PM +0200, Chris Mair wrote: >>Is there a better, faster way to do these inserts? > > COPY is generally the fastest way to do bulk inserts (see > PQputCopyData). Hi, I've rewritten the testclient now to use COPY, but I'm getting the exact same results as when doi

Re: [PERFORM] insertion of bytea

2005-10-25 Thread Chris Mair
>> 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

Re: [PERFORM] insertion of bytea

2005-10-25 Thread Chris Mair
>>Is there a better, faster way to do these inserts? > > COPY is generally the fastest way to do bulk inserts (see > PQputCopyData). Thanks :) I'll give that I try and report the results here later. Bye, Chris. ---(end of broadcast)--- TIP 4: Ha

Re: [PERFORM] insertion of bytea

2005-10-25 Thread Tom Lane
"Chris Mair" <[EMAIL PROTECTED]> writes: > 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 t

Re: [PERFORM] insertion of bytea

2005-10-25 Thread Michael Stone
On Tue, Oct 25, 2005 at 03:44:36PM +0200, Chris Mair wrote: Is there a better, faster way to do these inserts? COPY is generally the fastest way to do bulk inserts (see PQputCopyData). Mike Stone ---(end of broadcast)--- TIP 9: In versions bel

[PERFORM] insertion of bytea

2005-10-25 Thread Chris Mair
Hi, I have the following test setup: * PG 8.0.4 on Linux (Centos 4) compiled from source. * DB schema: essentially one table with a few int columns and one bytea column that stores blobs of 52000 bytes each, a primary key on one of the int columns. * A test client was written in C using lib