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