Postgres Pro
Downloads
Home   >   mailing lists

Re: Memory efficient insertion/retrieval of bytea - Mailing list pgsql-general

From Tom Lane
Subject Re: Memory efficient insertion/retrieval of bytea
Date
Msg-id 2870.1158763099@sss.pgh.pa.us
Whole thread Raw
In response to Memory efficient insertion/retrieval of bytea  (Tomasz Ostrowski <tometzky@batory.org.pl>)
Responses Re: Memory efficient insertion/retrieval of bytea  (Tomasz Ostrowski <tometzky@batory.org.pl>)
List pgsql-general
Tree view 
Tomasz Ostrowski <tometzky@batory.org.pl> writes:
> Now for inserting data to a bytea we need 5*data_size in a buffer for
> escaped data representation. 6*data_size if we do PQescapeByteaConn
> in one chunk.

If you send the value as an out-of-line binary parameter then you don't
need any of that.  See PQexecParams.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Strange database corruption with PostgreSQL 7.4.x on Debian Sarge
Next
From: Matthias.Pitzl@izb.de
Date:
Subject: Re: Strange database corruption with PostgreSQL 7.4.x o