>>>> Which pg version are you using? >> >> I should have mentionned that before sorry: PostgreSQL 8.2 > > I definitely would consider upgrading to 8.3 - even without any config > changes it might bring quite some improvement. > > But mainly it would allow you to use "asynchronous commit" - which could > possibly increase your throughput tremendously.
HOT can potentitally help a lot for this workload, too, if the columns being updated are not indexed. ...Robert -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
