Postgres Pro
Downloads
Home   >   mailing lists

Re: How can i be certain autovacuum is causing reuse if table still grows - Mailing list pgsql-admin

From David G. Johnston
Subject Re: How can i be certain autovacuum is causing reuse if table still grows
Date
Msg-id CAKFQuwYRfH0JMfubcKL=U6oo1cXrtb44H5O+ywXyuKDKg96_KA@mail.gmail.com
Whole thread Raw
In response to How can i be certain autovacuum is causing reuse if table still grows  (Sidney Aloisio Ferreira Pryor <sidney@tjrj.jus.br>)
Responses RE: How can i be certain autovacuum is causing reuse if table still grows  (Sidney Aloisio Ferreira Pryor <sidney@tjrj.jus.br>)
List pgsql-admin
Tree view
On Monday, July 27, 2020, Sidney Aloisio Ferreira Pryor <sidney@tjrj.jus.br> wrote:
Hi, we have a 9.6.5 postgres
 
Autovacuum is set with default parameters and is running on this table for days without naping or stopping.

 3285 | -5 days -23:33:10.792166 | postgres | autovacuum: VACUUM ANALYZE public.flip_pagina_edicao (to prevent wraparound)
(1 rows)


Its probably best avoid drawing conclusions here until the anti-wraparound vacuum has completed and you’ve updated to the latest minor version of PostgreSQL.

David J.

pgsql-admin by date:

Previous
From: Sidney Aloisio Ferreira Pryor
Date:
Subject: How can i be certain autovacuum is causing reuse if table still grows
Next
From: Sidney Aloisio Ferreira Pryor
Date:
Subject: RE: How can i be certain autovacuum is causing reuse if table still grows