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

From Alvaro Herrera
Subject Re: BUG #15005: ANALYZE can make pg_class.reltuples inaccurate.
Date
Msg-id 20180111143922.evxiss5q2n4ug74a@alvherre.pgsql
Whole thread Raw
Responses Re: BUG #15005: ANALYZE can make pg_class.reltuples inaccurate.
List pgsql-hackers
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.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


pgsql-hackers by date:

Previous
From: Dave Page
Date:
Subject: pgAdmin 4 v2.1 released!
Next
From: Dave Page
Date:
Subject: pgAdmin 4 commit: Tag REL-2_1 has been created.