On Mon, Nov 30, 2009 at 8:02 PM, Waldomiro <waldomiro@xxxxxxxxxx> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
