Re: slow full table update

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: firerox(at)centrum(dot)cz
Cc: pgsql-performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: slow full table update
Date: 2008-11-12 22:58:49
Message-ID: dcc563d10811121458t63499067ucd50e287d5c24a0@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

This is the critical point. You have this line:

There were 132969 unused item pointers.

Which says there's 132k or so dead rows in your table. Which means
vacuum / autovacuum isn't keeping up. Did you try and stop the update
several times? Each time it starts then gets killed it creates dead
rows.

Try doing a vacuum full followed by a reindex OR a cluster on this
table and see if that helps.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Scott Marlowe 2008-11-12 23:44:07 Re: Disk usage question
Previous Message firerox 2008-11-12 22:47:20 Re: slow full table update