| From: | Brad Nicholson <bnichols(at)ca(dot)afilias(dot)info> |
|---|---|
| To: | Rafael Domiciano <rafael(dot)domiciano(at)gmail(dot)com> |
| Cc: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>, Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, Julio Leyva <jcleyva(at)hotmail(dot)com>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: checkpoint_timeout |
| Date: | 2008-10-09 15:06:02 |
| Message-ID: | 1223564762.6070.14.camel@bnicholson-desktop |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Thu, 2008-10-09 at 13:02 -0200, Rafael Domiciano wrote:
> Hi there.
>
>
> I increased the wal_buffers and no change made.
> I'm beggining to think that my problem is not related to "checkpoint &
> cia" as I said early.
> I have decreased the checkpoint_timeout to 3 min and the slow down
> continuin' ocorring after each 5 min.
>
>
> In this "slowdown" the postgres does nothing, it's simply stop doing
> the operations. The softwares still waiting for the response.
> This is a dedicated server, the only program another postgres that
> runs is Slony-I
This sounds like checkpoint issues to me. Try adjusting the bgwriter
settings as suggested.
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2008-10-09 16:08:07 | Re: PLSQL function calling another function |
| Previous Message | Rafael Domiciano | 2008-10-09 15:02:57 | Re: checkpoint_timeout |