On Dec 22, 2007 12:10 AM, Marc <pgsql-general@xxxxxxxxxxxx> wrote:
Just a quick question, when were the tables vacuum analyzed last?
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.28 rows=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
