Re: [HACKERS] Template0 age is increasing speedily.

2006-09-07 Thread Merlin Moncure 

On 9/7/06, Nimesh Satam <[EMAIL PROTECTED]> wrote:

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.


possible checkpoint?  poorly formulated query?  it could be any number
of things.  use standard tools to diagnose the problem, including:

unix tools: top, vmstat, etc
postgresql query logging, including min_statement_duration
explain analyze

---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

  http://www.postgresql.org/docs/faq

[HACKERS] Template0 age is increasing speedily.

2006-09-07 Thread Nimesh Satam 
Hi!..
 
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.
 
 
 
Regards,
Nimesh.