Re: [BUGS] [HACKERS] Template0 age is increasing speedily.

#1

On 9/7/06, Nimesh Satam <nimesh.zedo (AT) gmail (DOT) com> wrote:

Quote:

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 5: don't forget to increase your free space map settings

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: [BUGS] [HACKERS] Template0 age is increasing speedily.

mailing.database.pgsql-bugs mailing.database.pgsql-bugs

Re: [BUGS] [HACKERS] Template0 age is increasing speedily. - 09-07-2006 , 10:46 AM