BLOBs

From: "Marin Dimitrov" <marin(dot)dimitrov(at)sirma(dot)bg>
To: <pgsql-jdbc(at)postgresql(dot)org>
Subject: BLOBs
Date: 2002-03-20 15:24:47
Message-ID: 002101c1d023$5eb07560$9b0e32d4@sirma.bg
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc


Hi,

what is the recommended way to work with LOBs in Postgres 7.2?

there are certain performance related issues with BYTEA if it is read as a
whole and not by chunks

on the other hand storing LOBs as Large Objects and using a propriety API
does not seem like a good idea to me (besides the docs mention more
limitation of the Large Objects method)

so I wander - what method do u people use to store LOBs when working with
JDBC applications? BYTEA is not quite the JDBC type LOB where u expect to
work with LOB locators and not retrieve the whole data record (similar to
Oracle's LONG), on the other hand working with Large Objects induces certain
inefficiency (custom API, certain limitations)

any advice?

thanx,

Marin

----
"...what you brought from your past, is of no use in your present. When
you must choose a new path, do not bring old experiences with you.
Those who strike out afresh, but who attempt to retain a little of the
old life, end up torn apart by their own memories. "

Responses

  • Re: BLOBs at 2002-03-21 04:04:21 from Joe Shevland

Browse pgsql-jdbc by date

  From Date Subject
Next Message Gonzalo Aranda 2002-03-20 17:10:57 tomcat +postgres
Previous Message Marin Dimitrov 2002-03-20 12:17:10 Re: [GENERAL] DriverManager.getConnection() fails sometimes but succeeds other times