Re: Still more REINDEX fun - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: Still more REINDEX fun
Date
Msg-id BANLkTi=FarX3XGke1tRg+yLfPd=PRtTyaA@mail.gmail.com
Whole thread Raw
In response to Still more REINDEX fun  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Still more REINDEX fun  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Wed, Apr 20, 2011 at 7:41 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:

> It's still true though that you have to be REINDEXing system catalogs to
> be at risk, else you shouldn't be seeing any IN_PROGRESS tuples.

So the fix seems to be that we make REINDEX on a system catalog lock
the whole catalog table.

Anything else seems likely to be heavily invasive, or at best
difficult to prove it is bug free.

--
 Simon Riggs                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services


pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: Formatting Curmudgeons WAS: MMAP Buffers
Next
From: Peter Eisentraut
Date:
Subject: Re: pl/python tracebacks v2