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]

Reply via email to