RE: [HACKERS] How to ignore system indexes

> -----Original Message-----
> From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
> 
> "Hiroshi Inoue" <Inoue@tpf.co.jp> writes:
> > 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 really necessary to touch all those places?
> 
> Seems to me that if a person needs to rebuild system indexes,
> he would be firing up a standalone backend and running
> REINDEX --- and darn little else.  As long as none of the
> support code required by REINDEX insists on using an index,
> it doesn't matter what the rest of the system requires.
>

OK,I would limit changes only for REINDEX command.
> You might even think about doing the reindex in bootstrap mode,
> though I don't know if that would be easier or harder.
>

Yes,bootstrap mode is a natural selection. Jan has already tried
it and there was a problem of time quliafication. I don't know it is
a big obstacle or not.  I prefer standalone postgres because
there's a possibility to call various SQL commands together
with REINDEX command.
Of cource,time qualification is no longer a problem in standalone
postgres.

Regards.

Hiroshi Inoue
Inoue@tpf.co.jp