On Mon, 23 Apr 2018 20:09:21 -0500 Justin Pryzby <pry...@telsasoft.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.29.1323717222303.JavaMail.root%40store1.zcs.ext.wpsrv.net#6373488.29.1323717222303.javamail.r...@store1.zcs.ext.wpsrv.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 da...@sonic.net If simplicity worked, the world would be overrun with insects.