Re: [patch] BUG #15005: ANALYZE can make pg_class.reltuples inaccurate.

On Mon, 23 Apr 2018 20:09:21 -0500
Justin Pryzby <pryzby(at)telsasoft(dot)com> wrote:

> Just want to add for the archive that I happened to run across what appears to
> be a 7-year old report of (I think) both of these vacuum/analyze bugs:
>
> Re: [patch] BUG #15005: ANALYZE can make pg_class.reltuples inaccurate.
> Re: [HACKERS] VACUUM and ANALYZE disagreeing on what reltuples means
>
> https://www.postgresql.org/message-id/flat/6373488(dot)29(dot)1323717222303(dot)JavaMail(dot)root%40store1(dot)zcs(dot)ext(dot)wpsrv(dot)net#6373488(dot)29(dot)1323717222303(dot)JavaMail(dot)root(at)store1(dot)zcs(dot)ext(dot)wpsrv(dot)net

Nice find. It does look like both, although, since the info is not in the
thread it is not certain that relpages was large enough to hit the analyze
issue. Unless that was with the old default statistics target in which case
it would be pretty easy to hit.

-dg

--
David Gould daveg(at)sonic(dot)net
If simplicity worked, the world would be overrun with insects.