Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group