Pavan Deolasee wrote: > 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.
Yep, that seems the most efficient approach. -- Bruce Momjian <[EMAIL PROTECTED]> http://momjian.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly