Re: Server Freezing - Mailing list pgsql-performance

From Robert Haas
Subject Re: Server Freezing
Date
Msg-id 603c8f070911301408x24697bbcif84bb69171e56d7f@mail.gmail.com
Whole thread Raw
In response to Server Freezing  (Waldomiro <waldomiro@shx.com.br>)
List pgsql-performance
On Mon, Nov 30, 2009 at 8:02 PM, Waldomiro <waldomiro@shx.com.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

pgsql-performance by date:

Previous
From: "Fernando Hevia"
Date:
Subject: Re: Server Freezing
Next
From: Greg Smith
Date:
Subject: Re: Server Freezing