From: | "Y Sidhu" <ysidhu(at)gmail(dot)com> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Subject: | Affect of Reindexing on Vacuum Times |
Date: | 2007-07-25 18:53:16 |
Message-ID: | b09064f30707251153x35a19e8cy3c4773090bff6ce0@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
I am wondering if reindexing heavily used tables can have an impact on
vacuum times. If it does, will the impact be noticeable the next time I
vacuum? Please note that I am doing vacuum, not vacuum full.
I am on a FreeBSD 6.1 Release, Postgresql is 8.09
Currently I seeing a phenomenon where vacuum times go up beyond 1 hour.
After I re-index 3 tables, heavily used, the vacuum times stay up for the
next 3 daily vacuums and then come down to 30 to 40 minutes. I am trying to
see if there is a relationship between re-indexinf and vacuum times. All
other things remain the same. Which means the only change I am performing is
re-indexing.
--
Yudhvir Singh Sidhu
408 375 3134 cell
http://theurbanturban.blogspot.com/
http://ysidhu.googlepages.com/
From | Date | Subject | |
---|---|---|---|
Next Message | Pavel Stehule | 2007-07-25 19:06:02 | Re: Simple select hangs while CPU close to 100% |
Previous Message | Jozsef Szalay | 2007-07-25 18:47:58 | Re: Simple select hangs while CPU close to 100% |