Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] Template0 age is increasing speedily.

From: "Merlin Moncure" <mmoncure(at)gmail(dot)com>
To: "Nimesh Satam" <nimesh(dot)zedo(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org, pgsql-bugs(at)postgresql(dot)org, pgsql-patches(at)postgresql(dot)org, pgsql-performance(at)postgresql(dot)org
Subject: Re: [HACKERS] Template0 age is increasing speedily.
Date: 2006-09-07 13:04:24
Message-ID: b42b73150609070604w2076948u799efc6e275fcf65@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-hackerspgsql-patchespgsql-performance
On 9/7/06, Nimesh Satam <nimesh(dot)zedo(at)gmail(dot)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

In response to

pgsql-performance by date

Next:From: Jeff DavisDate: 2006-09-07 16:56:01
Subject: Re: 64bit vs 32bit build on amd64
Previous:From: Dave DutcherDate: 2006-09-07 12:55:01
Subject: Re: [PATCHES] Template0 age is increasing speedily.

pgsql-hackers by date

Next:From: Gevik BabakhaniDate: 2006-09-07 13:35:59
Subject: Re: UUID/GUID discussion leading to request for
Previous:From: Dave DutcherDate: 2006-09-07 12:55:01
Subject: Re: [PATCHES] Template0 age is increasing speedily.

pgsql-bugs by date

Next:From: Bruce MomjianDate: 2006-09-07 15:37:25
Subject: Re: BUG #2606: (libpq) incorrect function declaration
Previous:From: Dave DutcherDate: 2006-09-07 12:55:01
Subject: Re: [PATCHES] Template0 age is increasing speedily.

pgsql-patches by date

Next:From: Tom LaneDate: 2006-09-07 14:59:16
Subject: Re: Timezone List
Previous:From: Dave DutcherDate: 2006-09-07 12:55:01
Subject: Re: [PATCHES] Template0 age is increasing speedily.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group