Horton

Re: bytea

David Garamond <lists@zara.6.isreserved.com>

View thread View on postgr.es
From: David Garamond <lists@zara.6.isreserved.com>
To: "scott.marlowe" <scott.marlowe@ihs.com>
Cc: Dennis Gearon <gearond@fireserve.net>, pgsql General List <pgsql-general@postgresql.org>
Date: 2004-05-12T15:28:03Z
Lists: 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