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 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]