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

Reply via email to