Re: VACUUM FULL versus system catalog cache invalidation

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Robert Haas" <robertmhaas(at)gmail(dot)com>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: VACUUM FULL versus system catalog cache invalidation
Date: 2011-08-12 19:16:15
Message-ID: 4E4535AF020000250003FE77@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Robert Haas <robertmhaas(at)gmail(dot)com> wrote:

> Perhaps we should just fix this one in master and consider
> back-patching it if and when we get some plausibly related bug
> reports.

I'm not completely clear on what one would do to be vulnerable to
hitting the bug, or what the impact of hitting it would be. Tom
said:

> The potential consequences are hugely worse than that, though:
> with a bit more time between the two operations, it'd be possible
> for someone else to reclaim the dead tuple and replace it with
> something else. As long as the TID is live when we get to it,
> heap_update will blindly replace it, whether or not it has
> anything to do with the tuple we think we're replacing.

What would a worst-case bug report based on hitting that look like?

-Kevin

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Heikki Linnakangas 2011-08-12 19:16:50 Inserting heap tuples in bulk in COPY
Previous Message Marko Kreen 2011-08-12 19:14:58 Re: sha1, sha2 functions into core?