[GENERAL] How are blobs (oid) stored?

[Jérôme Etévé]

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
jer...@eteve.net

--
Sent via pgsql-general mailing list (pgsql-...@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Tom Lane]

=?UTF-8?B?SsOpcsO0bWUgRXTDqXbDqQ==?= <jerome...@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

[Jérôme Etévé]

Thanks Tom.

J.

2009/11/26 Tom Lane <t...@sss.pgh.pa.us>:

> =?UTF-8?B?SsOpcsO0bWUgRXTDqXbDqQ==?= <jerome...@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
jer...@eteve.net

--