Gregory Stark wrote:
Alvaro Herrera [EMAIL PROTECTED] writes:
Alvaro Herrera [EMAIL PROTECTED] writes:
I am taking the liberty to also lower the vacuum and analyze threshold
default values to 50, per previous discussion.
Did we also reach any consensus about lowering the
Alvaro Herrera wrote:
Gregory Stark wrote:
Alvaro Herrera [EMAIL PROTECTED] writes:
Alvaro Herrera [EMAIL PROTECTED] writes:
I am taking the liberty to also lower the vacuum and analyze threshold
default values to 50, per previous discussion.
Did we also reach any consensus about lowering
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