From: Merlin Moncure <mmoncure@gmail.com>
To: Nimesh Satam <nimesh.zedo@gmail.com>
Cc: pgsql-hackers@postgresql.org
Cc: pgsql-bugs@postgresql.org
Cc: pgsql-patches@postgresql.org
Cc: pgsql-performance@postgresql.org
Subject: Re: [HACKERS] Template0 age is increasing speedily.
Date: Thu, 7 Sep 2006 09:04:24 -0400
Message-ID: <b42b73150609070604w2076948u799efc6e275fcf65@mail.gmail.com> (raw)
In-Reply-To: <965aa3ed0609070331y5749226eg91de0b376e343c75@mail.gmail.com>
References: <965aa3ed0609070331y5749226eg91de0b376e343c75@mail.gmail.com>
On 9/7/06, Nimesh Satam <nimesh.zedo@gmail.com> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: mmoncure@gmail.com, nimesh.zedo@gmail.com, pgsql-hackers@postgresql.org, pgsql-bugs@postgresql.org, pgsql-patches@postgresql.org
Subject: Re: [HACKERS] Template0 age is increasing speedily.
In-Reply-To: <b42b73150609070604w2076948u799efc6e275fcf65@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox