databases by 1.
-Original Message-From:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Nimesh
SatamSent: Thursday, September 07, 2006 5:49 AMTo: Chris
MairCc: pgsql-performance@postgresql.orgSubject: Re:
[PERFORM] [PATCHES] Template0 age is increasing speedily
In response to "Nimesh Satam" <[EMAIL PROTECTED]>:
> 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
>
> T
Hi,
Postgres Version used is 8.1.3
OS: Linux
'SELECT datname, age(datfrozenxid) FROM pg_database'
postgres | 1575xyz | 1073743934template1 | 1632template0 | 61540256
This is the command which I tried and got the above output, and the number is in
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..C
