Re: Is anyone aware of data loss causing MultiXact bugs in 9.3.2?

From: Peter Geoghegan <pg(at)heroku(dot)com>
To: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
Cc: Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Is anyone aware of data loss causing MultiXact bugs in 9.3.2?
Date: 2014-02-19 01:56:48
Message-ID: CAM3SWZS+CnS6S+vJtOjeQnzpUOOhwDqXL2CmFTY_NCmn-HW+qg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Feb 18, 2014 at 5:50 PM, Alvaro Herrera
<alvherre(at)2ndquadrant(dot)com> wrote:
> The multixact bugs would cause tuples to be hidden at the heap level.
> If the tuples are visible in a seqscan, then these are more likely to be
> related to index problems, not multixact problem.

That was my first suspicion, but then re-indexing didn't help, while
VACUUM FREEZE had the immediate effect of making both plans give a
consistent answer.

--
Peter Geoghegan

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Geoghegan 2014-02-19 02:03:07 Re: Is anyone aware of data loss causing MultiXact bugs in 9.3.2?
Previous Message Alvaro Herrera 2014-02-19 01:50:35 Re: Is anyone aware of data loss causing MultiXact bugs in 9.3.2?