> -----Original Message-----
> From: Bruce Momjian [mailto:pgman@candle.pha.pa.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@tpf.co.jp