On Wed, Oct 13, 2010 at 5:20 PM, Joe Miller wrote:
> Thanks for fixing the docs, but if that's the case, I shouldn't be
> seeing the behavior that I'm seeing.
>
> Should I flesh out this test case a little better and file a bug?
A reproducible test case is always a good thing to have...
--
Robe
Thanks for fixing the docs, but if that's the case, I shouldn't be
seeing the behavior that I'm seeing.
Should I flesh out this test case a little better and file a bug?
Thanks,
Joe
On Tue, Sep 21, 2010 at 4:44 PM, Tom Lane wrote:
> Joe Miller writes:
>> I was looking at the autovacuum docum
Joe Miller writes:
> I was looking at the autovacuum documentation:
> http://www.postgresql.org/docs/9.0/interactive/routine-vacuuming.html#AUTOVACUUM
>For analyze, a similar condition is used: the threshold, defined as:
>analyze threshold = analyze base threshold + analyze scale factor *
On Mon, Sep 20, 2010 at 6:28 PM, Kevin Grittner
wrote:
> Joe Miller wrote:
>
>> I can set up a cron job to run the ANALYZE manually, but it seems
>> like the autovacuum daemon should be smart enough to figure this
>> out on its own. Deletes can have as big an impact on the stats as
>> inserts an
I was looking at the autovacuum documentation:
http://www.postgresql.org/docs/9.0/interactive/routine-vacuuming.html#AUTOVACUUM
For analyze, a similar condition is used: the threshold, defined as:
analyze threshold = analyze base threshold + analyze scale factor *
number of tuples
is comp
Joe Miller writes:
> The autovacuum daemon currently uses the number of inserted and
> updated tuples to determine if it should run VACUUM ANALYZE on a
> table. Why doesnt it consider deleted tuples as well?
I think you misread the code.
Now there *is* a problem, pre-9.0, if your update patter
Joe Miller wrote:
> I can set up a cron job to run the ANALYZE manually, but it seems
> like the autovacuum daemon should be smart enough to figure this
> out on its own. Deletes can have as big an impact on the stats as
> inserts and updates.
But until the deleted rows are vacuumed from the
