Re: pg_filedump strangeness - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: pg_filedump strangeness
Date
Msg-id 20100406223359.GG3491@alvh.no-ip.org
Whole thread Raw
In response to Re: pg_filedump strangeness  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane wrote:
> Alvaro Herrera <alvherre@commandprompt.com> writes:
> > I'm chasing an apparent index corruption problem, and I came across
> > something I can't quite explain in pg_filedump.  Say I dump a non-leaf
> > btree index page:
> 
> I think this is actually OK.  Remember that in a non-rightmost page,
> item 1 is the high key not a data entry.

Oh, BTW, this is not what's corrupted about this index -- I just had
trouble following what pg_filedump was reporting.  The corruption is
more subtle: vacuum cannot find the parent page when trying to mark a
page for deletion.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: pg_filedump strangeness
Next
From: Tom Lane
Date:
Subject: Re: Win32 timezone matching