Re: About Large object Storage - Mailing list pgsql-general

From Adrian Klaver
Subject Re: About Large object Storage
Date
Msg-id 5357DA81.1050904@aklaver.com
Whole thread Raw
In response to Re: About Large object Storage  (Kalai R <softlinne.kv@gmail.com>)
List pgsql-general
On 04/23/2014 08:14 AM, Kalai R wrote:
> I have used custom format archieve in pg_dump.
>
> I have used the following command in plpgsql function to insert the image.
> lo_import(xlogopath)
>
> After I inserted one image more records are created in pg_largeobject
> and pg_largeobject_metadata tables other than the OID returned from
> lo_import

Large objects are stored in pg_largeobject in chunks, so this is not
surprising. See below for more detail:

http://www.postgresql.org/docs/current/static/catalog-pg-largeobject.html




--
Adrian Klaver
adrian.klaver@aklaver.com


pgsql-general by date:

Previous
From: Kalai R
Date:
Subject: Re: About Large object Storage
Next
From: Kal Black
Date:
Subject: WAL archiving from a standby backup strategy Postgresql 9.3