From: | Waldomiro <waldomiro(at)shx(dot)com(dot)br> |
---|---|
To: | Greg Smith <greg(at)2ndquadrant(dot)com> |
Cc: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Server Freezing |
Date: | 2009-12-01 11:02:47 |
Message-ID: | 4B14F7D7.5070407@shx.com.br |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
I´m using PostgreSQL 8.1. There is a way to see that?
Waldomiro
Greg Smith escreveu:
> Waldomiro wrote:
>> Is It possible the checkpoint is doing that? Or the archiving? How
>> can I see?
> If you're using PostgreSQL 8.3 or later, you can turn on
> log_checkpoints and you'll get a note when each checkpoint finishes.
> The parts that are more likely to slow the server down are right at
> the end, so if you see a bunch of slow queries around the same time as
> the checkpoint message appears in the logs, that's the likely cause.
> Bad checkpoint behavior can certainly cause several seconds of
> freezing on a system with 32GB of RAM, because with that much data you
> can have quite a bit in the OS write cache that all gets forced out at
> the end of the checkpoint.
>
> Finding when the checkpoints happen on 8.2 or earlier is much harder;
> I can tell you what to look for on Linux for example, but it's kind of
> painful to track them down.
>
From | Date | Subject | |
---|---|---|---|
Next Message | Waldomiro | 2009-12-01 11:18:54 | Re: Server Freezing |
Previous Message | Waldomiro | 2009-12-01 01:02:33 | Server Freezing |