Re: [PERFORM] template1 vacuuming consuming much time compared to another production DBs

blem. FYI there is much load on OS this time. And why vacuuming of template1 only consumes time not other DBs? On Mon, Apr 22, 2013 at 9:08 PM, Andrew Dunstan wrote: > > On 04/22/2013 07:31 AM, pradeep singh wrote: > >> Hi, >> >> >> I am using postgresql 8.1 DB.

[PERFORM] template1 vacuuming consuming much time compared to another production DBs

Hi, I am using postgresql 8.1 DB. I have a large DB and i run the vacuum every hour with "vocuumdb --analyze -a" option. Some times template1 consumes much time in comparison to my own DB.I think at these times the load on OS is higher. But from iostat logs i can see that the load on the partitio