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

From Álvaro Herrera
Subject Re: vacuum process running for more than 2 days, still in scanning heap phase
Date
Msg-id 202511121900.6boicrjyyy3i@alvherre.pgsql
Whole thread Raw
In response to Re: vacuum process running for more than 2 days, still in scanning heap phase  (Sbob <sbob@quadratum-braccas.com>)
Responses Re: vacuum process running for more than 2 days, still in scanning heap phase
List pgsql-admin
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?

-- 
Álvaro Herrera         PostgreSQL Developer  —  https://www.EnterpriseDB.com/
"We’ve narrowed the problem down to the customer’s pants being in a situation
 of vigorous combustion" (Robert Haas, Postgres expert extraordinaire)



pgsql-admin by date:

Previous
From: Pavan Kumar
Date:
Subject: Re: vacuum process running for more than 2 days, still in scanning heap phase
Next
From: Sbob
Date:
Subject: Re: vacuum process running for more than 2 days, still in scanning heap phase