autovacuum blocks the operations of other manual vacuum

From: kuopo <spkuo(at)cs(dot)nctu(dot)edu(dot)tw>
To: pgsql-performance(at)postgresql(dot)org
Subject: autovacuum blocks the operations of other manual vacuum
Date: 2010-11-12 08:01:24
Message-ID: AANLkTimNrG6JA6MbMb52T5CVt+hi_hsD_fW6NRDkARgH@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi,

I have a question about the behavior of autovacuum. When I have a big
table A which is being processed by autovacuum, I also manually use
(full) vacuum to clean another table B. Then I found that I always got
something like “found 0 removable, 14283 nonremovable row”. However,
if I stop the autovacuum functionality and use vacuum on that big
table A manually, I can clean table B (ex. found 22615 removable, 2049
nonremovable row).

Is this correct? Why do vacuum and autovacuum have different actions?

Ps. My postgreSQL is 8.4.

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Cédric Villemain 2010-11-12 09:07:31 Re: anti-join chosen even when slower than old plan
Previous Message Pavel Stehule 2010-11-12 04:38:35 Re: postmaster consuming /lots/ of memory with hash aggregate. why?