Re: bytea - Mailing list pgsql-general

From David Garamond
Subject Re: bytea
Date
Msg-id 40A24283.7010100@zara.6.isreserved.com
Whole thread Raw
In response to Re: bytea  ("scott.marlowe" <scott.marlowe@ihs.com>)
List pgsql-general
scott.marlowe wrote:
> And yes, toasting is fully automatic.  Just insert a large
> text/varchar/bytea field and the database does the rest.  which is why
> they are generally recommended over using large objects, which require
> specialized handling.

They are not always recommended though. The manual clearly states that
bytea/text's drawback is huge memory requirement (esp. for large
data/long text) and lack of chunk processing. Hopefully this will be
addressed in the future.

--
dave

pgsql-general by date:

Previous
From: Dennis Gearon
Date:
Subject: Domains with constraints?
Next
From: "Ed L."
Date:
Subject: Re: Identifying diskspace leakage