Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

procmail + change subject, w2ksp4.exe download, /proc/kallsyms format, sqldatasource dal, wwwxxxenden, convert raid5 to raid 10 mdadm, apache force chunked, nrao wwwxxx, xxxxxdup, procmail change subject header

Links

XODOX
Impressum

#1: Lob Streaming

Posted on 2011-02-07 16:00:06 by Ramesh Reddy

Hi,

Does psql-odbc driver support lob streaming? I could successfully get
'bytea' content, but for large size > GB lobs I am running into memory
issues. Can you body suggest any alternatives.

Thanks

Ramesh..


--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Report this message

#2: Re: Lob Streaming

Posted on 2011-02-07 17:18:24 by Richard Broersma

--20cf3054a4f1d5c7eb049bb394f0
Content-Type: text/plain; charset=ISO-8859-1

On Mon, Feb 7, 2011 at 7:00 AM, Ramesh Reddy <rareddy@redhat.com> wrote:

> Hi,
>
> Does psql-odbc driver support lob streaming? I could successfully get
> 'bytea' content, but for large size > GB lobs I am running into memory
> issues. Can you body suggest any alternatives.
>

Try using the PostgreSQL contrib module "lo."

http://www.postgresql.org/docs/9.0/interactive/lo.html

also see:
http://www.postgresql.org/docs/9.0/interactive/vacuumlo.html

--
Regards,
Richard Broersma Jr.

--20cf3054a4f1d5c7eb049bb394f0
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<br><br><div class=3D"gmail_quote">On Mon, Feb 7, 2011 at 7:00 AM, Ramesh R=
eddy <span dir=3D"ltr">&lt;<a href=3D"mailto:rareddy@redhat.com">rareddy@re=
dhat.com</a>&gt;</span> wrote:<br><blockquote class=3D"gmail_quote" style=
=3D"margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); p=
adding-left: 1ex;">
Hi,<br>
<br>
Does psql-odbc driver support lob streaming? I could successfully get<br>
&#39;bytea&#39; content, but for large size &gt; GB lobs I =A0am running in=
to memory<br>
issues. Can you body suggest any alternatives.<br></blockquote><div>=A0</di=
v>Try using the PostgreSQL contrib module &quot;lo.&quot;<br>
<br>
<a href=3D"http://www.postgresql.org/docs/9.0/interactive/lo.html">http://w=
ww.postgresql.org/docs/9.0/interactive/lo.html</a></div><br>also see:<br><a=
href=3D"http://www.postgresql.org/docs/9.0/interactive/vacuu mlo.html">http=
://www.postgresql.org/docs/9.0/interactive/vacuumlo.html</a><br clear=3D"al=
l">
<br>-- <br>Regards,<br>Richard Broersma Jr.<br>

--20cf3054a4f1d5c7eb049bb394f0--

Report this message

#3: Re: Lob Streaming

Posted on 2011-02-09 16:22:27 by Ramesh Reddy

Thank you for the info.

I am afraid, the code I see in the ODBC driver is not doing streaming.
It makes one lo_read call based on the buffer size configured in your
client and truncates the rest of the content.

What I would like to have seen is, driver making a small length lo_read
calls to fill up the buffer size provided by the client, then truncate
if the size is larger, not request one huge chuck of read from the
server.

Ramesh..

On Mon, 2011-02-07 at 08:18 -0800, Richard Broersma wrote:
>
>
> On Mon, Feb 7, 2011 at 7:00 AM, Ramesh Reddy <rareddy@redhat.com>
> wrote:
> Hi,
>
> Does psql-odbc driver support lob streaming? I could
> successfully get
> 'bytea' content, but for large size > GB lobs I am running
> into memory
> issues. Can you body suggest any alternatives.
>
> Try using the PostgreSQL contrib module "lo."
>
> http://www.postgresql.org/docs/9.0/interactive/lo.html
>
> also see:
> http://www.postgresql.org/docs/9.0/interactive/vacuumlo.html
>
> --
> Regards,
> Richard Broersma Jr.



--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Report this message