> > 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.


---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at


Reply via email to