Re: Nasty bug in heap_page_prune - Mailing list pgsql-hackers

From Hannu Krosing
Subject Re: Nasty bug in heap_page_prune
Date
Msg-id 1204884765.6568.1.camel@huvostro
Whole thread Raw
In response to Nasty bug in heap_page_prune  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Nasty bug in heap_page_prune  ("Pavan Deolasee" <pavan.deolasee@gmail.com>)
List pgsql-hackers
On Wed, 2008-03-05 at 20:23 -0500, Tom Lane wrote:

> Not sure about a clean solution to this.  I don't really want to
> bastardize inval.c by making it deal with nontransactional semantics,
> but there may be no other way.

Is this something that happens only with concurrent VACUUM FULLs ?

If so, than can't we just disallow doing them concurrently ?

VACUUM FULL is something you don't want on a high-load database anyway

> Or we could forget about letting VACUUM FULL collapse out LP_REDIRECT
> pointers, at least in system catalogs.  That might be the best answer
> for 8.3 in any case; I am not seeing a real fix that I'd care to risk
> back-patching.  (Note that this is not exactly trivial in itself, since
> then vacuum.c would need at least some minimal ability to deal with
> LP_REDIRECT entries.)
> 
>             regards, tom lane

Hannu Krosing




pgsql-hackers by date:

Previous
From: "Pavan Deolasee"
Date:
Subject: Re: 8.3.0 Core with concurrent vacuum fulls
Next
From: "Pavan Deolasee"
Date:
Subject: Re: Nasty bug in heap_page_prune