Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

Next:From: Greg SmithDate: 2009-12-01 00:08:09
Subject: Re: Server Freezing
Previous:From: Fernando HeviaDate: 2009-11-30 20:12:18
Subject: Re: Server Freezing

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group