Skip site navigation (1) Skip section navigation (2)

Re: BYTEA Fields and Memory Consumption

From: Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
To: Raiford(at)labware(dot)com
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: BYTEA Fields and Memory Consumption
Date: 2011-04-14 03:41:45
Message-ID: 4DA66CF9.8080408@tpf.co.jp (view raw or flat)
Thread:
Lists: pgsql-odbc
Hi,

(2011/04/13 21:09), Raiford(at)labware(dot)com wrote:
> I have an issue where even though I break a large BYTEA object up into
> multiple pieces, the ODBC driver just rejoins the pieces in memory and
> tries to send it all out at once. I took a look at the code and sure
> enough the driver just keeps reallocating memory for each chunk of data
> that I add.

Yes you are right.

 > Can I assume Postgres has no mechanism to send this data
> across the wire in pieces? Are there any common practices for dealing
> with this?

Please try lo type instead of bytea type.

regards,
Hiroshi Inoue

 > As it is, in one environment I can only transfer files around
> 50MB before I start receiving out of memory errors. The same program
> running against Oracle and SQL Server works great.
>
> Jon


In response to

Responses

pgsql-odbc by date

Next:From: Josef SpringerDate: 2011-04-14 08:36:49
Subject: 08.02.04.00 Updating column with Unicode does not work
Previous:From: RaifordDate: 2011-04-13 12:09:25
Subject: BYTEA Fields and Memory Consumption

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group