Re: Questions about large objects and the WAL

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Karen Ploski <ploskikl(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Questions about large objects and the WAL
Date: 2006-03-01 06:22:41
Message-ID: 7068.1141194161@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Karen Ploski <ploskikl(at)yahoo(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Roman Neuhauser 2006-03-01 11:13:42 Re: majordomo unmaintained, postmaster emails ignored?
Previous Message Michael Fuhr 2006-03-01 06:18:10 Re: Data corruption zero a file - help!!