Re: slow full table update - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: slow full table update
Date
Msg-id dcc563d10811121458t63499067ucd50e287d5c24a0@mail.gmail.com
Whole thread Raw
In response to Re: slow full table update  (<firerox@centrum.cz>)
Responses Re: slow full table update  (Tomas Vondra <tv@fuzzy.cz>)
List 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.

pgsql-performance by date:

Previous
From:
Date:
Subject: Re: slow full table update
Next
From: "Scott Marlowe"
Date:
Subject: Re: Disk usage question