Re: [HACKERS] Index corruption - Mailing list pgsql-hackers

From Jan Wieck
Subject Re: [HACKERS] Index corruption
Date
Msg-id 38735666.AB28504B@debis.com
Whole thread Raw
In response to RE: [HACKERS] Index corruption  ("Hiroshi Inoue" <Inoue@tpf.co.jp>)
List pgsql-hackers
Hiroshi Inoue wrote:

> > -----Original Message-----
> > From: owner-pgsql-hackers@postgreSQL.org
> > [mailto:owner-pgsql-hackers@postgreSQL.org]On Behalf Of Jan Wieck
>
> >     Thus,  IMHO  there  should  be  another  command added to the
> >     bootstrap parser.  This would recreate ALL  existing  indices
> >     (system  and user ones), but tell the visibility code somehow
> >     to ignore deleted tuples. I don't have the time to do it now,
> >     so at least I'd like to have a TODO item for it.
> >
>
> I may be able to implement reindex command unless you have
> the time to do it.
>
> Different from your suggestion,I would implement it in a non-bootstrap
> standalone postgres with the new option by which PostgreSQL ignores
> system indexes.
    Sounds good to me.



Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#========================================= wieck@debis.com (Jan Wieck) #





pgsql-hackers by date:

Previous
From: Karel Zak - Zakkr
Date:
Subject: Re: [HACKERS] ordinal decimal number
Next
From: Hannu Krosing
Date:
Subject: Re: [HACKERS] ordinal decimal number