On Mon, Jan 26, 2009 at 03:49:00PM +0100, Thomas Finneid wrote:
> Kenneth Marshall wrote:
>> It may be that the smaller index has update contention for the same
>> blocks that the larger index does not.
> Is that an assumption based on both indexes existing? if so I might agree,
> but if you are talking about only one index existing at a time then could
> you explain what the basis for you conclusion is?
The small index blocks would look like:
and the large index:
|axxx|...|bxxx|...|cxxx|... and so on.
Now, if you try to update a-k, the small index will be trying to
update and possibly rearrange/split/... items on the same disk
blocks while the larger index would be updating without contention.
It may not even be block level contention, the same argument applies
to cachelines with in a block.
In response to
pgsql-performance by date
|Next:||From: M. Edward (Ed) Borasky||Date: 2009-01-26 16:10:41|
|Subject: Re: postgresql 8.3 tps rate|
|Previous:||From: Thomas Finneid||Date: 2009-01-26 14:49:00|
|Subject: Re: strange index performance?|