Zeugswetter Andreas ADI SD wrote:
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 ?
Yes. In the first set of results, SELECT on accounts is removed.
Seems that should also show improvements.
Do you prune chains during update also ?
Yes, we do prune the chains during UPDATE, but only when we
run out of free space and LP_DELETEd items on the page.
And we prune all chains on the page in that case.
Thanks,
Pavan
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
