Re: ASSM and Indexes

From: Nuno Souto <>
Date: Sun, 03 Jan 2010 20:31:29 +1100
Message-ID: <>

Tanel Poder wrote,on my timestamp of 3/01/2010 3:09 PM:

> If we leave all the bugs out, then if you do use ASSM for your tables,
> then there's no reason not to use them for indexes as well. However I
> know few shops who have went back to freelists because constant trouble
> they had with ASSM.
> Nevertheless, I default to ASSM nowadays (as we need to tune our own
> time usage as well !!!) and look into freelists usage only on case by
> case basis.

We had our fair share of problems with ASSM. Since, also patched up for some of the most glaring and obvious ASSM bu^H^Hfeatures, it's been tremendously stable for us. To the point where I don't even bother with non-ASSM anymore.

Nuno Souto
in rainy Sydney, Australia
Received on Sun Jan 03 2010 - 03:31:29 CST

Original text of this message