| 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 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-hackers pgsql-patches pgsql-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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2006-09-07 15:37:25 | Re: BUG #2606: (libpq) incorrect function declaration |
| Previous Message | Dave Dutcher | 2006-09-07 12:55:01 | Re: [PATCHES] Template0 age is increasing speedily. |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gevik Babakhani | 2006-09-07 13:35:59 | Re: UUID/GUID discussion leading to request for |
| Previous Message | Dave Dutcher | 2006-09-07 12:55:01 | Re: [PATCHES] Template0 age is increasing speedily. |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2006-09-07 14:59:16 | Re: Timezone List |
| Previous Message | Dave Dutcher | 2006-09-07 12:55:01 | Re: [PATCHES] Template0 age is increasing speedily. |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Davis | 2006-09-07 16:56:01 | Re: 64bit vs 32bit build on amd64 |
| Previous Message | Dave Dutcher | 2006-09-07 12:55:01 | Re: [PATCHES] Template0 age is increasing speedily. |