Re: Rework the way multixact truncations work - Mailing list pgsql-hackers

From Robert Haas
Subject Re: Rework the way multixact truncations work
Date
Msg-id CA+TgmoYQB34mFsHzqmJC4Kc=JcZ6-Rm1niMa2NRpggeR5zQP4g@mail.gmail.com
Whole thread Raw
In response to Re: Rework the way multixact truncations work  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
Responses Re: Rework the way multixact truncations work  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-hackers
On Mon, Sep 28, 2015 at 10:48 PM, Jim Nasby <Jim.Nasby@bluetreble.com> wrote:
> Maybe I'm confused, but I thought the whole purpose of this was to get rid
> of the risk associated with that calculation in favor of explicit truncation
> boundaries in the WAL log.

Yes.  But if the master hasn't been updated yet, then we still need to
do something based on a calculation.

> Even if that's not the case, ISTM that being big and in your face about a
> potential data corruption bug is a good thing, as long as the DBA has a way
> to "hit the snooze button".

Panicking the standby because the master hasn't been updated does not
seem like a good thing to me in any way.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Comment update to pathnode.c
Next
From: Joel Jacobson
Date:
Subject: Re: Rework the way multixact truncations work