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

Поиск
Список
Период
Сортировка
От Álvaro Herrera
Тема Re: vacuum process running for more than 2 days, still in scanning heap phase
Дата
Msg-id 202511121900.6boicrjyyy3i@alvherre.pgsql
обсуждение исходный текст
Ответ на Re: vacuum process running for more than 2 days, still in scanning heap phase  (Sbob <sbob@quadratum-braccas.com>)
Ответы Re: vacuum process running for more than 2 days, still in scanning heap phase
Список 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 по дате отправления: