My other idea was that there are so many indexes on this table, maybe the update is slow because of the indexes?Updating indexes is certainly very far from being free. How many is "many"?
Number of indexes = 15. 3 indexex are on "text" type column, 500MB in size each. Other are on int8 and timestamp columns, cca. 200MB each. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
