Re: strange index performance? - Mailing list pgsql-performance

From Thomas Finneid
Subject Re: strange index performance?
Date
Msg-id 497DCD5C.6070500@fcon.no
Whole thread Raw
In response to Re: strange index performance?  (Kenneth Marshall <ktm@rice.edu>)
Responses Re: strange index performance?  (Kenneth Marshall <ktm@rice.edu>)
List pgsql-performance
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?

regards

thomas


pgsql-performance by date:

Previous
From: Kenneth Marshall
Date:
Subject: Re: strange index performance?
Next
From: Kenneth Marshall
Date:
Subject: Re: strange index performance?