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

From: Álvaro Herrera <alvherre(at)kurilemu(dot)de>
To: Sbob <sbob(at)quadratum-braccas(dot)com>
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:01:15
Message-ID: 202511121900.6boicrjyyy3i@alvherre.pgsql
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: 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)

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Sbob 2025-11-12 19:08:37 Re: vacuum process running for more than 2 days, still in scanning heap phase
Previous Message Pavan Kumar 2025-11-12 18:59:36 Re: vacuum process running for more than 2 days, still in scanning heap phase