Thread: 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