On 30.08.2011 13:29, Alexander Korotkov wrote:
> On Tue, Aug 30, 2011 at 1:13 PM, Heikki Linnakangas<
> heikki(dot)linnakangas(at)enterprisedb(dot)com> wrote:
>> So, over 50% of the CPU time is spent in choosing a block from the
>> temporary files. That should be pretty easy to improve..
> Yes, probably we can just remove free blocks sorting.
I'm re-running the tests with that change now. It seems like using the
list of free blocks as a simple stack would be better anyway, it
probably yields a better cache hit ratio when we re-use blocks that have
just been released.
In response to
pgsql-hackers by date
|Next:||From: Heikki Linnakangas||Date: 2011-08-30 10:43:23|
|Subject: Re: WIP: Fast GiST index build|
|Previous:||From: Pavan Deolasee||Date: 2011-08-30 10:38:44|
|Subject: Re: Single pass vacuum - take 2|