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.
In response to
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|