the bytea limit is 1gb (as are all datums in postgres).
pg_largeobject can go up to 2gb, but in either case you'd likely run
into severe performance/scalability issues long before objects began
approaching those size because of memory usage and other issues. With
100kb objects though, you shoul
On Mon, Oct 19, 2009 at 9:11 PM, David Wall wrote:
> We have a system in which a large amount of the data is stored as large
> objects now in PG 8.4. The relational aspects of these objects are stored
> using traditional tables, but we store a lot of binary data (files, images)
> and XML objects
We have a system in which a large amount of the data is stored as large
objects now in PG 8.4. The relational aspects of these objects are
stored using traditional tables, but we store a lot of binary data
(files, images) and XML objects that are compressed and then encrypted.
The ACID proper