On Dec 22, 2007 12:10 AM, Marc <[EMAIL PROTECTED]> wrote: > Hey Folks, > > This query is running really slowly. Sometimes much slower then others. > I have a feeling that there may be contention on one of the indices it is > using. > > Query and explain plan are below. Seems like it spend the most time doing > > Index Scan using i_tablea_atextfield on tablea ru (cost=0.00..2265.28rows=2 > width=12) (actual time= > 0.624..881.313 rows=228 loops=1) > > Any suggestions? > > Just a quick question, when were the tables vacuum analyzed last?
-- Usama Munir Dar http://www.linkedin.com/in/usamadar Consultant Architect Cell:+92 321 5020666 Skype: usamadar