Re: Is Autovacuum running?

From: Christophe Pettus <xof(at)thebuild(dot)com>
To: Brad White <b55white(at)gmail(dot)com>
Cc: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Is Autovacuum running?
Date: 2023-02-21 17:57:09
Message-ID: F7B3F7F2-B5A0-491E-B7AE-9456BAF39F5B@thebuild.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> On Feb 21, 2023, at 09:54, Brad White <b55white(at)gmail(dot)com> wrote:
> Any suggestions on how to proceed?

First, look at pg_stat_user_tables to see how many inserts etc. have occurred on the tables that are not showing an autovacuum; they may have simply not reached the threshold yet. If they have, do a VACUUM VERBOSE across the database and make sure that you can manually vacuum them, or if it reports that it can't remove tuples.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Brad White 2023-02-21 18:48:57 Re: Is Autovacuum running?
Previous Message Brad White 2023-02-21 17:54:22 Re: Is Autovacuum running?