Qing,
> My guess is that all the queries that involves the columns that are
> being indexed need to
> be rewritten to use the newly created indexes to avoid the performance
> issues. The reason
> is that REINDEX does not help either. Does it make sense?
What's the rate of updates on the newly indexed tables? If you have a lot
of updates, the work that the database does to keep the indexes current would
put a big load on your server. This is far more likely to be the cause of
your issues.
--
--Josh
Josh Berkus
Aglio Database Solutions
San Francisco