RE: [HACKERS] How to ignore system indexes

> -----Original Message-----
> From: Bruce Momjian [mailto:pgman(at)candle(dot)pha(dot)pa(dot)us]
>
> > I'm trying to implement REINDEX command.
> > Because the command is to repair system indexes,we
> > coundn't rely on system indexes when we call the
> > command.
> >
> > I added locally an option of standalone postgres to ignore
> > system indexes and am add/changing ignore_system_
> > indexes stuff.
> >
> > There are fairly many places using system indexes.
> > Probably I would be able to change them.
> > But is it preferable or possible to force other developers
> > to take ignore_system_indexes mode into account ?
> > Is it better to limit changes required for REINDEX
> > command ?
>
> One solution is to use pg_upgrade. It allows an initdb and recreate of
> all tables without reload.
> --

Isn't it a big charge to execute pg_upgrade for a huge database ?
I have never used pg_upgrade.
Is pg_upgrade available now ?
Is pg_upgrade reliable ?

My design is as follows.

postgres -P test /* I'm using -P as a new option temporarily */.

> reindex database test; (all system indexes of a db)
> reindex table pg_class; (all indexes of a system table)
> reindex index pg_index_indexrelid_index; (a system index)

If we could ignore system indexes,it won't be difficult to implement
REINDEX command itself..

Regards.

Hiroshi Inoue
Inoue(at)tpf(dot)co(dot)jp