Re: very slow update query

Ilija Vidoevski <ilija.vidoevski@yahoo.com> writes:
> This is table DDL

What I asked for was EXPLAIN ANALYZE output ... but anyway, the thing
that jumps out at me about that DDL is the six extremely wide indexes
(not even counting the primary key index).  It seems very unlikely
that those are going to repay their update maintenance costs.  I'd
try dropping all but the primary key and seeing if that improves the
update-speed situation at all.  If it does, I'd suggest reading
something about Postgres-oriented index design before you add anything
back.  There's material in the manual here:
http://www.postgresql.org/docs/9.1/static/indexes.html
but the key points I think you are missing is that indexes with more
than a few columns are seldom worth the trouble, and indexes with
identical leading columns are even more seldom worth the trouble.

            regards, tom lane