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 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match