How are blobs (oid) stored?

=?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