> The advantage is that you can then index a bunch more of the system
> catalog tables, and on a bunch more attributes. That produced some
> surprising speedups.
We have indexes on all system tables that need it. The pg_index index
was done quite easily and is new for 7.0. A check for recursion and
fallback to sequential scan for pg_index table rows in the pg_index
table allows it to happen.
-- 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