On Jul 24, 2007, at 1:02 AM, Gregory Stark wrote:
"Alvaro Herrera" <[EMAIL PROTECTED]> writes:
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?
Well let me flip it around. Would you think a default
"Alvaro Herrera" <[EMAIL PROTECTED]> writes:
> 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?
Well let me flip it around. Would you think a default fillfactor of 10% would
be helpful or overkill? I
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.
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 lower
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 abou