For an educated guess what to do, you would have to provide us with an exact table definition including all indexes, triggers, foreign key and other constraints, with the typical UPDATE statements you are running, your PostgreSQL version, basic hardware and configuration, concurrent load ...