Re: strange index performance?

From: Thomas Finneid <tfinneid(at)fcon(dot)no>
To: Kenneth Marshall <ktm(at)rice(dot)edu>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: strange index performance?
Date: 2009-01-26 14:49:00
Message-ID: 497DCD5C.6070500@fcon.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Kenneth Marshall 2009-01-26 15:37:09 Re: strange index performance?
Previous Message Kenneth Marshall 2009-01-26 13:50:59 Re: strange index performance?