> > accounts 157895 (initial size) 49284 (increase) > > accounts_pkey 19709 (initial size) 19705 (increase) > > > > > Just to clarify, the relation size and increase is in number > of blocks.
The numbers are quite impressive :-) Have you removed the selects on accounts too ? Seems that should also show improvements. Do you prune chains during update also ? This seems important for a scenario where only few selects but many updates happen. Andreas ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate