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

help / color / mirror / Atom feed
From: MichaelDBA <MichaelDBA@sqlexec.com>
To: Keith Fiske <keith.fiske@crunchydata.com>
Cc: Scott Ribe <scott_ribe@elevated-dev.com>
Cc: Sidney Aloisio Ferreira Pryor <sidney@tjrj.jus.br>
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: Wed, 5 Aug 2020 09:29:17 -0400
Message-ID: <23135c5d-3a17-108a-e59b-a7fa8446fec0@sqlexec.com> (raw)
In-Reply-To: <CAODZiv6PAs=AuqgJH4O-r3A7TmfkHjc168omVeWKiAoiuDf6fg@mail.gmail.com>
References: <FR1PR80MB071069E71B2758BB9D187EC18C770@FR1PR80MB0710.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>
	<CAODZiv6PAs=AuqgJH4O-r3A7TmfkHjc168omVeWKiAoiuDf6fg@mail.gmail.com>

Hi Keith,

I think statistics are also reset and not persistent through restarts 
when the pg_ctl option "-m immediate" is used when shutting down PG 
since it forces recovery mode when starting PG back up.  By the way, for 
PostgreSQL Aurora, statistics are reset automatically every time aurora 
forces PG to restart or reboot or the user selects that option 
manually.  I reported this as a bug with Aurora a few months ago.  They 
said it was not a bug, but a feature that the might implement in the 
future.  YUK.

Regards,
Michael Vitale


Keith Fiske wrote on 8/4/2020 6:25 PM:
>
>
> On Tue, Aug 4, 2020 at 3:54 PM Scott Ribe <scott_ribe@elevated-dev.com 
> <mailto:scott_ribe@elevated-dev.com>> wrote:
>
>     > On Aug 4, 2020, at 12:31 PM, Sidney Aloisio Ferreira Pryor
>     <sidney@tjrj.jus.br <mailto: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.
>
>
> 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

view thread (12+ messages)  latest in thread

Message-ID: <23135c5d-3a17-108a-e59b-a7fa8446fec0@sqlexec.com>
Permalink:  ../23135c5d-3a17-108a-e59b-a7fa8446fec0@sqlexec.com/
Also on:    postgresql.org/message-id/23135c5d-3a17-108a-e59b-a7fa8446fec0@sqlexec.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: MichaelDBA@sqlexec.com, keith.fiske@crunchydata.com, scott_ribe@elevated-dev.com, sidney@tjrj.jus.br, 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: <23135c5d-3a17-108a-e59b-a7fa8446fec0@sqlexec.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