Re: Image storage questions - Mailing list pgsql-general

From Noel
Subject Re: Image storage questions
Date
Msg-id efhn81942f62e7sah0gtr52b0eiqf1dpip@4ax.com
Whole thread Raw
In response to Image storage questions  ("Ed L." <pgsql@bluepolka.net>)
List pgsql-general
On Wed, 18 May 2005 14:07:18 -0700, jd@commandprompt.com ("Joshua D.
Drake") wrote:

>Large Objects stream (for lack of a better term) to the client in 8k?
>chunks so it typically isn't too bad.

>Bytea gives you everything all at once which is fine for small objects.

Isn't there also a difference between the two in terms of the largest
amount of data they can handle?

>External storing is useful but I prefer LO because all my data (binary
>and meta) is all in the same place for management.

As well as ensuring data integrity, of course.

pgsql-general by date:

Previous
From: rama mohan
Date:
Subject: Callable Statements are not supported at this time
Next
From: palanivel.kumaran@scandent.com
Date:
Subject: need clarification