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