Re: BUG #15005: ANALYZE can make pg_class.reltuples inaccurate. - Mailing list pgsql-bugs

From David Gould
Subject Re: BUG #15005: ANALYZE can make pg_class.reltuples inaccurate.
Date
Msg-id 20180122235224.22bf654d@engels
Whole thread Raw
In response to Re: BUG #15005: ANALYZE can make pg_class.reltuples inaccurate.  (David Gould <daveg@sonic.net>)
List pgsql-bugs
On Thu, 11 Jan 2018 11:39:22 -0300
Alvaro Herrera <alvherre@alvh.no-ip.org> wrote:

> David Gould wrote:
> 
> > I've tracked down how this happens and created a reproduction script and a
> > patch. Attached:
> > 
> > - vac_estimate_reltuples.patch     Patch against master
> > - README.txt                       Instructions for testing
> > - reltuples_analyze_bug.sql        Reproduction script
> > - analyze_counts.awk               Helper for viewing results of test
> > - test_standard.txt                Test output for unpatched postgresql 10.1
> > - test_patched.txt                 Test output with patch  
> 
> Great work.  Please make sure to register this as a bug fix in the
> next commitfest.
> 

Done last week. See:

https://www.postgresql.org/message-id/flat/20180117164916.3fdcf2e9@engels/

I think this should be considered for back-patching, the bug exists in all
versions back to 9.4 (and probably earlier, but I did not test those).

-dg

-- 
David Gould                                   daveg@sonic.net
If simplicity worked, the world would be overrun with insects.


pgsql-bugs by date:

Previous
From: Amit Kapila
Date:
Subject: Re: Problem running post-install step.
Next
From: Amit Kapila
Date:
Subject: Re: Problem running post-install step.