Обсуждение: How are blobs (oid) stored?
Hi all, I know this is none of the user's business, but I'm wondering how blob's implemented as oid are stored in the postgresql data storage. Are each of them kept in a separate file, or are they chunked into pieces and scattered ? Thanks ! Jerome. -- Jerome Eteve. http://www.eteve.net jerome@eteve.net
=?UTF-8?B?SsOpcsO0bWUgRXTDqXbDqQ==?= <jerome.eteve@gmail.com> writes: > I know this is none of the user's business, but I'm wondering how > blob's implemented as oid are stored in the postgresql data storage. > Are each of them kept in a separate file, or are they chunked into > pieces and scattered ? They're in chunks in the pg_largeobject catalog. http://developer.postgresql.org/pgdocs/postgres/catalog-pg-largeobject.html regards, tom lane
Thanks Tom. J. 2009/11/26 Tom Lane <tgl@sss.pgh.pa.us>: > =?UTF-8?B?SsOpcsO0bWUgRXTDqXbDqQ==?= <jerome.eteve@gmail.com> writes: >> I know this is none of the user's business, but I'm wondering how >> blob's implemented as oid are stored in the postgresql data storage. >> Are each of them kept in a separate file, or are they chunked into >> pieces and scattered ? > > They're in chunks in the pg_largeobject catalog. > http://developer.postgresql.org/pgdocs/postgres/catalog-pg-largeobject.html > > regards, tom lane > -- Jerome Eteve. http://www.eteve.net jerome@eteve.net