Re: Questions about large objects and the WAL - Mailing list pgsql-general

From Tom Lane
Subject Re: Questions about large objects and the WAL
Date
Msg-id 7068.1141194161@sss.pgh.pa.us
Whole thread Raw
In response to Questions about large objects and the WAL  (Karen Ploski <ploskikl@yahoo.com>)
List pgsql-general
Karen Ploski <ploskikl@yahoo.com> writes:
> I'm trying to understand how large objects relate to
> the write-ahead log.

Large objects are just some data in a table.  The API for them is a bit
odd, but the reliability issues are not any different from any other
transaction.

> (1)When a large object is updated, how much of the
> large object is placed in the WAL buffers in shared
> memory by LogInsert?

Every row you updated (which is any 2K segment of the
large object IIRC).

            regards, tom lane

pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: Data corruption zero a file - help!!
Next
From: Roman Neuhauser
Date:
Subject: Re: majordomo unmaintained, postmaster emails ignored?