Re: [PATCHES] Template0 age is increasing speedily.

Hi,

Postgres Version used is 8.1.3
OS: Linux

'SELECT datname, age(datfrozenxid) FROM pg_database'

postgres | 1575
xyz | 1073743934
template1 | 1632
template0 | 61540256

This is the command which I tried and got the above output, and the number
is increasing pretty fast for template0.

Please let me know if this a problem.

Regards,
Nimesh.

On 9/7/06, Chris Mair <chrisnospam(at)1006(dot)org> wrote:
>
> On Thu, 2006-09-07 at 16:01 +0530, Nimesh Satam wrote:
>
> > I noticed that the age of template0 is increasing very rapidly..Can
> > you please let me know how we can control this ....and what causes
> > such problems.
> >
> > We also noticed that the database slow downs heavily at a particular
> > time..Can you suggest any tools which will help in diagnosing the root
> > cause behiond the data load.
>
>
> Hi,
>
> first of all: there is no need to cross post on 4 lists.
> If you have a performance problem, post on pgsql-performance.
>
> Second, please tell us which version of PostgreSQL on
> which operating system you're using. Diagnosing your
> problem might depend on which OS you use...
>
> Finally, explain what you mean by "the age of template0 is
> increasing very rapidly", you mean "the size is increasing"?
>
> Bye,
> Chris.
>
>
>
> --
>
> Chris Mair
> http://www.1006.org
>
>