aravind chandu wrote: > Blobs stores large amount can you please tell me > what is the limit i.e hw many kb of data can it store ? say > 4000k like that. > > For suppose if a 4000kb data can be stored using > blob and the data stored in blob is 3600k what about the > remaining data? will it allocates all the 4000kb data or will > it allocates only 3600kb data? Like char(100) it will > allocates all 100 bytes in memory and varchar(100) which is > variable memory?
There are actually two data types that provide BLOB functionality: Large Objects, which can be up to 2GB in size (http://www.postgresql.org/docs/current/static/lo-intro.html) and bytea, which can be up to 1GB in size (http://www.postgresql.org/docs/current/static/datatype-binary.html). Read the documentation for the pros and cons of each. Both will only use (about) as much disk space as the actual object needs. Yours, Laurenz Albe -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
