Alvaro Herrera <[EMAIL PROTECTED]> wrote: > We didn't, but while I agree with the idea, I think 5% is too low. I > don't want autovacuum to get excessively aggressive. Is 10% not enough?
I think the threshold should be a little less than PCTFREE of indexes, to avoid splitting of btree leaves. It might be good to decrease the fillfactor to 85% or so when we choise 10% for it. Regards, --- ITAGAKI Takahiro NTT Open Source Software Center ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
