pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Scott Ribe <scott_ribe@elevated-dev.com>
To: Sidney Aloisio Ferreira Pryor <sidney@tjrj.jus.br>
Cc: Keith Fiske <keith.fiske@crunchydata.com>
Cc: Guillaume Lelarge <guillaume@lelarge.info>
Cc: Ron <ronljohnsonjr@gmail.com>
Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Re: How can i be certain autovacuum is causing reuse if table still grows
Date: Tue, 4 Aug 2020 13:53:58 -0600
Message-ID: <FBBB8A4B-C5F9-4A44-924A-043AEA0D6D02@elevated-dev.com> (raw)
In-Reply-To: <CP2PR80MB07070C7676AF764A3477D1A38C4A0@CP2PR80MB0707.lamprd80.prod.outlook.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>

> On Aug 4, 2020, at 12:31 PM, Sidney Aloisio Ferreira Pryor <sidney@tjrj.jus.br> 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.






view thread (12+ messages)  latest in thread

Message-ID: <FBBB8A4B-C5F9-4A44-924A-043AEA0D6D02@elevated-dev.com>
Permalink:  ../FBBB8A4B-C5F9-4A44-924A-043AEA0D6D02@elevated-dev.com/
Also on:    postgresql.org/message-id/FBBB8A4B-C5F9-4A44-924A-043AEA0D6D02@elevated-dev.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: scott_ribe@elevated-dev.com, sidney@tjrj.jus.br, keith.fiske@crunchydata.com, guillaume@lelarge.info, ronljohnsonjr@gmail.com, pgsql-admin@lists.postgresql.org
  Subject: Re: How can i be certain autovacuum is causing reuse if table still grows
  In-Reply-To: <FBBB8A4B-C5F9-4A44-924A-043AEA0D6D02@elevated-dev.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox