BYTEA Fields and Memory Consumption

Поиск
Список
Период
Сортировка
От Raiford@labware.com
Тема BYTEA Fields and Memory Consumption
Дата
Msg-id OF30EF0461.6F402208-ON85257871.00422A74-85257871.0042C717@labware.com
обсуждение исходный текст
Ответ на problem with 09.0.0200  (Andreas <maps.on@gmx.net>)
Ответы Re: BYTEA Fields and Memory Consumption
Список pgsql-odbc
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.  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?  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

В списке pgsql-odbc по дате отправления:

Предыдущее
От: Hiroshi Inoue
Дата:
Сообщение: Re: problem with 09.0.0200
Следующее
От: Hiroshi Inoue
Дата:
Сообщение: Re: BYTEA Fields and Memory Consumption