On Wed, Jan 21, 2009 at 01:55:28PM +0000, Grzegorz Ja??kiewicz wrote: > there's no real limit (its size is described with 32bit number, and > that's the only limitation here). > But you need to be aware, that content is sent over at once, so memory > is the limit in your case. > > http://www.postgresql.org/docs/8.3/static/datatype-binary.html > > For such large objects, it might be actually better to store them > separate as files, and just store file name. > The TOAST implementation however only allows 30-bits for the size of the TOAST entry which caps the size at 2^30 or 1GB. I agree that he could very well be limited also by the memory on his system. Cheers, Ken -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
