BYTEA maximum sizes (Re: Storing jpgs) - Mailing list pgsql-general

From David Garamond
Subject BYTEA maximum sizes (Re: Storing jpgs)
Date
Msg-id 40738A7B.2010703@zara.6.isreserved.com
Whole thread Raw
In response to Re: Storing jpgs  ("Rod K" <rod@23net.net>)
List pgsql-general
Rod K wrote:
> I've found bytea works better for me than large objects.

Speaking of BYTEA, what is the recommended maximum sizes for data to be
put in there. I've played with megabytes-sized BYTEA and the memory
requirement is pretty huge... Is it possible for BYTEA to be efficient
and supporting chunk processing in the future? Is BYTEA and TEXT the
future of all lobs?

--
dave


pgsql-general by date:

Previous
From: David Garamond
Date:
Subject: Re: SQL trees and other nonsense...
Next
From: Tom Lane
Date:
Subject: Re: PERFORM statement inside procedure