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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance