Re: Server Freezing

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Waldomiro <waldomiro(at)shx(dot)com(dot)br>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Server Freezing
Date: 2009-11-30 22:08:15
Message-ID: 603c8f070911301408x24697bbcif84bb69171e56d7f@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Mon, Nov 30, 2009 at 8:02 PM, Waldomiro <waldomiro(at)shx(dot)com(dot)br> wrote:
> Its not a vaccum needed, becouse I do a TRUNCATE every night.

But you're updating each row 20 times a day - you could very well need a vacuum.

> Is It possible the checkpoint is doing that? Or the archiving? How can I
> see?

It seems likely to be caused by checkpoint I/O or vacuuming activity,
but I'm not sure how to figure out which.

...Robert

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Greg Smith 2009-12-01 00:08:09 Re: Server Freezing
Previous Message Fernando Hevia 2009-11-30 20:12:18 Re: Server Freezing