MIME-Version: 1.0
References: 
 <CAOC+FBVsecrnc-dzt-pZ-orMe2i=kxZ9WHBFQrk6_PEu7zyniw@mail.gmail.com>
In-Reply-To: 
 <CAOC+FBVsecrnc-dzt-pZ-orMe2i=kxZ9WHBFQrk6_PEu7zyniw@mail.gmail.com>
From: Wells Oliver <wells.oliver@gmail.com>
Date: Wed, 28 Aug 2024 21:21:12 -0700
Message-ID: 
 <CAOC+FBV0Q_E=cMnE4c06yMz-WBg7XbhwCN3Cf09s9GYSU4jRAA@mail.gmail.com>
Subject: Re: pg_repack and table statistics
To: pgsql-admin <pgsql-admin@postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000003581860620cad07a"
Archived-At: 
 <https://www.postgresql.org/message-id/CAOC%2BFBV0Q_E%3DcMnE4c06yMz-WBg7XbhwCN3Cf09s9GYSU4jRAA%40mail.gmail.com>
Precedence: bulk

--0000000000003581860620cad07a
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Hmm, apologies, I'd delete this if I could, I was looking at stale data for
pg_stat_user_tables, it indeed has a n_dead_tup of 0 after a repack.

On Wed, Aug 28, 2024 at 9:16=E2=80=AFPM Wells Oliver <wells.oliver@gmail.co=
m> wrote:

> I find that the n_dead_tup value in pg_stat_user_tables is the same befor=
e
> and after a successful pg_repack of that table (ditto all the values
> really). Is there something that should be done after a repack to have
> those stats updated, or is their unchanging value a sign of repack failin=
g
> for some reason?
>
> --
> Wells Oliver
> wells.oliver@gmail.com <wellsoliver@gmail.com>
>


--=20
Wells Oliver
wells.oliver@gmail.com <wellsoliver@gmail.com>

--0000000000003581860620cad07a
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div class=3D"gmail_default" style=3D"font-size:small">Hmm=
, apologies, I&#39;d delete this if I could, I was looking at stale data fo=
r pg_stat_user_tables, it indeed has a n_dead_tup of 0 after a repack.</div=
></div><br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr"=
>On Wed, Aug 28, 2024 at 9:16=E2=80=AFPM Wells Oliver &lt;<a href=3D"mailto=
:wells.oliver@gmail.com">wells.oliver@gmail.com</a>&gt; wrote:<br></div><bl=
ockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-lef=
t:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><div class=
=3D"gmail_default" style=3D"font-size:small">I find that the=C2=A0n_dead_tu=
p value in=C2=A0pg_stat_user_tables is the same before and after a successf=
ul pg_repack of that table (ditto all the values really). Is there somethin=
g that should be done after a repack to have those stats updated, or is the=
ir unchanging value a sign of repack failing for some reason?</div><div><br=
></div><span class=3D"gmail_signature_prefix">-- </span><br><div dir=3D"ltr=
" class=3D"gmail_signature"><div dir=3D"ltr"><div>Wells Oliver<br><a href=
=3D"mailto:wellsoliver@gmail.com" target=3D"_blank">wells.oliver@gmail.com<=
/a></div></div></div></div>
</blockquote></div><br clear=3D"all"><div><br></div><span class=3D"gmail_si=
gnature_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_signature"><d=
iv dir=3D"ltr"><div>Wells Oliver<br><a href=3D"mailto:wellsoliver@gmail.com=
" target=3D"_blank">wells.oliver@gmail.com</a></div></div></div>

--0000000000003581860620cad07a--