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

In response to

• Re: HOT - preliminary results at 2007-03-01 15:43:01 from Zeugswetter Andreas ADI SD

Responses

• Re: HOT - preliminary results at 2007-03-02 20:52:47 from Bruce Momjian

pgsql-hackers by date

Next:	From: Tom Lane	Date: 2007-03-02 07:06:49
	Subject: Re: [GENERAL] Fun with Cursors- how to rewind a cursor
Previous:	From: John Bartlett	Date: 2007-03-02 06:47:46
	Subject: Re: [PATCHES] - WIP Patch Updatable Cursor