Re: How are blobs (oid) stored? - Mailing list pgsql-general

From Jérôme Etévé
Subject Re: How are blobs (oid) stored?
Date
Msg-id f516fcd80911260807k49256ae3g8a5dbd4f3f41a5ba@mail.gmail.com
Whole thread Raw
In response to Re: How are blobs (oid) stored?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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

pgsql-general by date:

Previous
From: "Jean-Yves F. Barbier"
Date:
Subject: transparently log a right error
Next
From: "Shak"
Date:
Subject: Invalid redo in checkpoint record