Re: How can i be certain autovacuum is causing reuse if table still grows

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: Scott Ribe <scott_ribe@xxxxxxxxxxxxxxxx>
Subject: Re: How can i be certain autovacuum is causing reuse if table still grows
From: Keith Fiske <keith.fiske@xxxxxxxxxxxxxxx>
Date: Tue, 4 Aug 2020 18:25:38 -0400
Cc: Sidney Aloisio Ferreira Pryor <sidney@xxxxxxxxxxx>, Guillaume Lelarge <guillaume@xxxxxxxxxxxx>, Ron <ronljohnsonjr@xxxxxxxxx>, "pgsql-admin@xxxxxxxxxxxxxxxxxxxx" <pgsql-admin@xxxxxxxxxxxxxxxxxxxx>
In-reply-to: <FBBB8A4B-C5F9-4A44-924A-043AEA0D6D02@elevated-dev.com>
References: <FR1PR80MB071069E71B2758BB9D187EC18C770@FR1PR80MB0710.lamprd80.prod.outlook.com> <CP2PR80MB0707AE54D878CA370750BE908C720@CP2PR80MB0707.lamprd80.prod.outlook.com> <CAKFQuwYRfH0JMfubcKL=U6oo1cXrtb44H5O+ywXyuKDKg96_KA@mail.gmail.com> <CP2PR80MB0707312D852432398C61BDD08C720@CP2PR80MB0707.lamprd80.prod.outlook.com> <CAODZiv5PeT90z6Ou4pgj9s39oBoYbB6STy_azMSekeDHUCHAEQ@mail.gmail.com> <CP2PR80MB0707395805CE22D89FEB3D278C720@CP2PR80MB0707.lamprd80.prod.outlook.com> <CAODZiv7MrqtzMAZ2vZs5gS1Rv935zjggdZmKAyAVZB6a5H1AJQ@mail.gmail.com> <20d2fb88-89f8-34b9-0e23-81a8b1d8c7a2@gmail.com> <CP2PR80MB07072BAFCF4B2824E8D567788C730@CP2PR80MB0707.lamprd80.prod.outlook.com> <2500ca1c-312e-c495-ad98-1b593d030c71@gmail.com> <FC651D1B-0AD4-419B-B923-92E05439884A@tjrj.jus.br> <CAODZiv4EqkNJ8rOAvth2mmb=06T5j=6Q1yNxLVcM-h8yAobV1A@mail.gmail.com> <CP2PR80MB0707B010FEDFE1298BDDEBF18C730@CP2PR80MB0707.lamprd80.prod.outlook.com> <CP2PR80MB07072818C87DCA6B9066A2278C4D0@CP2PR80MB0707.lamprd80.prod.outlook.com> <CAECtzeUwzjaX2KqT4oFiodFpCw7PSsVSj_21OuYvz+uU_8M29A@mail.gmail.com> <CAODZiv44=9FnNZwVGBagj-K655oBouWMNrNS8hJO1qoAH1rYWA@mail.gmail.com> <CP2PR80MB070728ADF02B93831D3FCD268C4A0@CP2PR80MB0707.lamprd80.prod.outlook.com> <CAODZiv5a79+2VjRr0HSLdwe__1uJHhoiDFOdOC3xwd_rFWx2sA@mail.gmail.com> <CP2PR80MB070746BB714F54099B9CFE998C4A0@CP2PR80MB0707.lamprd80.prod.outlook.com> <CP2PR80MB07070C7676AF764A3477D1A38C4A0@CP2PR80MB0707.lamprd80.prod.outlook.com> <FBBB8A4B-C5F9-4A44-924A-043AEA0D6D02@elevated-dev.com>

On Tue, Aug 4, 2020 at 3:54 PM Scott Ribe <scott_ribe@xxxxxxxxxxxxxxxx> wrote:

> On Aug 4, 2020, at 12:31 PM, Sidney Aloisio Ferreira Pryor <sidney@xxxxxxxxxxx> wrote:
>
> Beside this, i saw on pg_stat_tables and the vacuum and autovacuum count for this table is 0.

Those values are not persistent; they are only since the last start of PG.

This is not correct. Statistics are persistent through restarts. They are only reset during specific cases such as a crash or a major version upgrade. They can also be reset at any time manually.

Keith Fiske
Senior Database Engineer
Crunchy Data - http://crunchydata.com

Follow-Ups:
- Re: How can i be certain autovacuum is causing reuse if table still grows
  - From: MichaelDBA

References:
- How can i be certain autovacuum is causing reuse if table still grows
  - From: Sidney Aloisio Ferreira Pryor
- Re: How can i be certain autovacuum is causing reuse if table still grows
  - From: David G. Johnston
- RE: How can i be certain autovacuum is causing reuse if table still grows
  - From: Sidney Aloisio Ferreira Pryor
- Re: How can i be certain autovacuum is causing reuse if table still grows
  - From: Keith Fiske
- RE: How can i be certain autovacuum is causing reuse if table still grows
  - From: Sidney Aloisio Ferreira Pryor
- Re: How can i be certain autovacuum is causing reuse if table still grows
  - From: Keith Fiske
- Re: How can i be certain autovacuum is causing reuse if table still grows
  - From: Ron
- RE: How can i be certain autovacuum is causing reuse if table still grows
  - From: Sidney Aloisio Ferreira Pryor
- Re: How can i be certain autovacuum is causing reuse if table still grows
  - From: Ron
- Re: How can i be certain autovacuum is causing reuse if table still grows
  - From: Sidney Aloisio Ferreira Pryor
- Re: How can i be certain autovacuum is causing reuse if table still grows
  - From: Keith Fiske
- RE: How can i be certain autovacuum is causing reuse if table still grows
  - From: Sidney Aloisio Ferreira Pryor
- RE: How can i be certain autovacuum is causing reuse if table still grows
  - From: Sidney Aloisio Ferreira Pryor
- Re: How can i be certain autovacuum is causing reuse if table still grows
  - From: Guillaume Lelarge
- Re: How can i be certain autovacuum is causing reuse if table still grows
  - From: Keith Fiske
- RE: How can i be certain autovacuum is causing reuse if table still grows
  - From: Sidney Aloisio Ferreira Pryor
- Re: How can i be certain autovacuum is causing reuse if table still grows
  - From: Keith Fiske
- RE: How can i be certain autovacuum is causing reuse if table still grows
  - From: Sidney Aloisio Ferreira Pryor
- RE: How can i be certain autovacuum is causing reuse if table still grows
  - From: Sidney Aloisio Ferreira Pryor
- Re: How can i be certain autovacuum is causing reuse if table still grows
  - From: Scott Ribe

Prev by Date: RE: How can i be certain autovacuum is causing reuse if table still grows
Next by Date: Re: How can i be certain autovacuum is causing reuse if table still grows
Previous by thread: RE: How can i be certain autovacuum is causing reuse if table still grows
Next by thread: Re: How can i be certain autovacuum is causing reuse if table still grows
Index(es):
- Date
- Thread

[Index of Archives] [KVM ARM] [KVM ia64] [KVM ppc] [Virtualization Tools] [Spice Development] [Libvirt] [Libvirt Users] [Linux USB Devel] [Linux Audio Users] [Yosemite Questions] [Linux Kernel] [Linux SCSI] [XFree86]