Cosimo Streppone <cosimo(at)streppone(dot)it> writes:
> The performance level of Pg 8 is at least *five* times higher
> (faster!) than 7.1.3 in "query-intensive" transactions,
> which is absolutely astounding.
Cool.
> In my experience, Pg8 handles far better non-unique indexes
> with low cardinality built on numeric and integer types, which
> is very common in our application.
Yes, we've fixed a number of places where the btree code was inefficient
with large numbers of equal keys. I'm not sure that that explains a
5x speedup all by itself, though.
regards, tom lane