On Samstag, 2. April 2011, Henry C. wrote:
> I just noticed something odd: I'm busy with a manual vacuum on a
> table and an autovacuum keeps firing up as well.
Usually a manual vacuum cancels a running autovacuum task.
You should find a notice about the cancelation in th logfile.
> current_query | vacuum analyze
> age | 11:46:57.245568
Where is the age column from?
It's not in pg_stat_activity.
Is one of the two processes waiting=t in pg_stat_activity?
Shure it's the same Table? Do you have one Table named
page_citation_text in public and one in anoter sheme?
> I'm trying to vacuum the table as quickly as possible so a manual
> vacuum seems to be in order as my understanding (and experience)
> is that the autovac is a hell of a lot slower to mitigate impact
> on general performance.
Tune the autovacuum settings, especially the scale factors of the
tables in question and the cost limit.
Is autovacuum_vacuum_cost_limit != -1 ?
This could be one reason, why manual vacuum is faster.
Nevertheless since at least 8.4 IMO there's no need to bother with
manual vacuum any more.
Regards, Jens
