Re: vacuum process running for more than 2 days, still in scanning heap phase

From: Sbob <sbob(at)quadratum-braccas(dot)com>
To:
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: vacuum process running for more than 2 days, still in scanning heap phase
Date: 2025-11-12 19:08:37
Message-ID: fb783ccd-811c-4cc9-aa9d-d60549dbd389@quadratum-braccas.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin


On 11/12/25 12:01 PM, Álvaro Herrera wrote:
> On 2025-Nov-12, Sbob wrote:
>
>> This is not autovacuum, we ran a vacuum freeze manyally
> Oh, well, I guess this might be very slow if it decides to freeze a lot
> of tuples. Maybe have a look at the rate at which it generates WAL.
>
> Why did you run vacuum freeze anyway?

working with a new client, have not yet uncovered why but they run these
vacuum freeze ops daily

>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Sbob 2025-11-12 19:10:11 vacuumdb produces ERROR: cannot freeze committed xmax
Previous Message Álvaro Herrera 2025-11-12 19:01:15 Re: vacuum process running for more than 2 days, still in scanning heap phase