Postgres Pro
Downloads
Home   >   mailing lists

Thread: template1 vacuuming consuming much time compared to another production DBs

template1 vacuuming consuming much time compared to another production DBs

From
pradeep singh
Date:
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

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

From
Andrew Dunstan
Date:
On 04/22/2013 07:31 AM, pradeep singh wrote:
> Hi,
>
>
> I am using postgresql 8.1 DB.

Why are you using a release of Postgres that is way out of date and
unsupported?

cheers

andrew

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

From
pradeep singh
Date:
I am using this DB since last 3 or 4 years. And suddenly we can't update it.
We are planning it at the end of year. Recently we faced the template1 wraparound issue. So we added template1 also for vacuuming. We are vacuuming the DB each hour with 'vacuumdb --analyze -a' options.
Now the vacuuming of template1 consumes time. And the queries become slow. From the logs i find that during this we period there are lot of backend processes in startup state. so i think connection open is slow. They are waiting on WCHAN log_wait_.
So could you please recommend what may be the problem. 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 <andrew@dunslane.net> wrote:

On 04/22/2013 07:31 AM, pradeep singh wrote:
Hi,


I am using postgresql 8.1 DB.

Why are you using a release of Postgres that is way out of date and unsupported?

cheers

andrew






--
pradeep singh
biet jhansi