information related to blobs
Hello,
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?
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