Hi,
My databases are updated regularly so I am vacuuming frequently (every one hour). Recently i also added template1 database to avoid over wrapping problem. But somehow i am seeing strange behavior.
Most of the time all db vacuuming finish in 30 secs.
but once in a day or two
- My actual DB is taking less than 30 secs for vacuuming.
- Sometime template1 is taking 5 mins for vacuuming.
- Queries become exceptionally slow at that time for 5 mins ( specially during the end).
I am wondering what could be the reason of long time of template1 vacumming sometime and slow query at end of vacumming.
Do we need to template1 analyze regularly? What is ideal frequency of template1 vacuuming only and analyze?
My DB version is little old - 8.1.18.