Re: pg_subtrans and WAL

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Alvaro Herrera Munoz <alvherre(at)dcc(dot)uchile(dot)cl>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: pg_subtrans and WAL
Date: 2004-08-16 16:09:31
Message-ID: 200408161609.i7GG9VQ20496@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


Added to open items:

* determine proper crash recovery/logging for pg_subtrans

---------------------------------------------------------------------------

Alvaro Herrera Munoz wrote:
> On Tue, Aug 10, 2004 at 12:24:06PM -0400, Tom Lane wrote:
> > My discovery last night of a WAL synchronization error in pg_clog led me
> > to take a look at pg_subtrans too. I soon realized that in fact we are
> > not WAL-logging pg_subtrans updates at all: subtransaction start sets up
> > a pg_subtrans entry but makes no WAL entry for this action.
> >
> > Seems like this is a problem.
>
> Rats :-(
>
> You are probably right. In fact this was on my todo list and I overlooked
> it -- it was mentioned during early discussion.
>
> Right now I am heading to Bolivia for a conference, so I am not able to
> do anything codewise right now, and I'll most likely have very intermitent
> connection ... I'll be back on monday 16.
>
> --
> Alvaro Herrera (<alvherre[(at)]dcc(dot)uchile(dot)cl>)
> "Estoy de acuerdo contigo en que la verdad absoluta no existe...
> El problema es que la mentira s? existe y tu est?s mintiendo" (G. Lama)
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2004-08-16 16:14:27 Re: Tablespace issues (comment on ,moving indexes)
Previous Message Tom Lane 2004-08-16 16:07:13 Re: HASHes [was Re: Calling PL functions with named parameters]