Request a Demo
Home   >   mailing lists

Re: vacuum process running for more than 2 days, still in scanning heap phase - Mailing list pgsql-admin

From Sbob
Subject Re: vacuum process running for more than 2 days, still in scanning heap phase
Date
Msg-id fb783ccd-811c-4cc9-aa9d-d60549dbd389@quadratum-braccas.com
Whole thread Raw
In response to Re: vacuum process running for more than 2 days, still in scanning heap phase  (Álvaro Herrera <alvherre@kurilemu.de>)
List pgsql-admin
Tree view 
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


>

pgsql-admin by date:

Previous
From: Álvaro Herrera
Date:
Subject: Re: vacuum process running for more than 2 days, still in scanning heap phase
Next
From: Sbob
Date:
Subject: vacuumdb produces ERROR: cannot freeze committed xmax