Re: n00b autovacuum question - Mailing list pgsql-performance

From Andreas Pflug
Subject Re: n00b autovacuum question
Date
Msg-id 441C4758.9000205@pse-consulting.de
Whole thread Raw
In response to n00b autovacuum question  (Antoine <melser.anton@gmail.com>)
Responses Re: n00b autovacuum question
List pgsql-performance
Antoine wrote:
> Hi,
> I have enabled the autovacuum daemon, but occasionally still get a
> message telling me I need to run vacuum when I access a table in
> pgadmin.

pgAdmin notices a discrepancy between real rowcount and estimated
rowcount and thus suggests to run vacuum/analyze; it won't examine
autovacuum rules so it might warn although autovac is running ok.

If you're sure autovacuum is running fine, just dismiss the message.
It's a hint for newbies that do *not* run vacuum because they don't know
what it's good for.

Regards
Andreas

pgsql-performance by date:

Previous
From: "Matthew T. O'Connor"
Date:
Subject: Re: n00b autovacuum question
Next
From: Chris Travers
Date:
Subject: Re: firebird X postgresql 8.1.2 windows, performance comparison