RE: [HACKERS] How to ignore system indexes

> -----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