Re: [HACKERS] How to ignore system indexes - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [HACKERS] How to ignore system indexes
Date
Msg-id 200001180404.XAA07081@candle.pha.pa.us
Whole thread Raw
In response to How to ignore system indexes  ("Hiroshi Inoue" <Inoue@tpf.co.jp>)
Responses RE: [HACKERS] How to ignore system indexes
List pgsql-hackers
> 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.
--  Bruce Momjian                        |  http://www.op.net/~candle pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-hackers by date:

Previous
From: Tatsuo Ishii
Date:
Subject: multi-byte support broken in current
Next
From: "Hiroshi Inoue"
Date:
Subject: RE: [HACKERS] How to ignore system indexes