Re: Performance (was: The New Slashdot Setup (includes MySql server))

> 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