template1 vacuuming consuming much time compared to another production DBs

From: pradeep singh <pradeepsingh1988(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: template1 vacuuming consuming much time compared to another production DBs
Date: 2013-04-22 11:31:13
Message-ID: CA+TUHZXGvmvG+5gyv3ZwFHvdky4ny_9oP07JuVo4YaVzKwPHYw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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 partition where DB resides is not too
much.
I would like to know why such thing happens?
What are the processing that is carried out with the template1 vacuuming.
When the entries in template1 is updated and inserted?
What should be the frequency of template1 vacuuming?
Is template1 is updated as frequent as my own DB is updated?

Thanks,
Pradeep

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Andrew Dunstan 2013-04-22 12:08:19 Re: template1 vacuuming consuming much time compared to another production DBs
Previous Message Ireneusz Pluta 2013-04-22 08:26:08 Re: - why only 9.1?