Cosimo Streppone <[EMAIL PROTECTED]> 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.


> 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

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to