Improve row estimates for empty tables

Title

Topic

Performance

Created

2020-08-23 21:10:09

Last modified

2020-08-30 16:22:18 (4 years, 2 months ago)

Latest email

2020-08-30 17:13:31 (4 years, 2 months ago)

Status

2020-09: Committed

Target version

Authors

Tom Lane (tgl)

Reviewers

Pavel Stehule (okbobcz)Become reviewer

Committer

Tom Lane (tgl)

Links

Checkout latest CFbot patchset

Go to your local checkout of the PostgreSQL repository and run:

git remote add commitfest https://github.com/postgresql-cfbot/postgresql.git
git fetch commitfest cf/2691
git checkout commitfest/cf/2691

Emails

Row estimates for empty tables: First at 2020-07-24 04:01:25 by Christophe Pettus <xof at thebuild.com>
Latest at 2020-08-30 17:13:31 by Pavel Stehule <pavel.stehule at gmail.com>
Latest attachment (use-minus-one-for-unknown-reltuples-1.patch) at 2020-08-23 21:08:16 from Tom Lane <tgl at sss.pgh.pa.us>
    Attachment (use-minus-one-for-unknown-reltuples-1.patch) at 2020-08-23 21:08:16 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (fakepages.patch) at 2020-07-25 03:40:08 from Pavel Stehule <pavel.stehule at gmail.com> (Patch: Yes)
    Attachment (set-relpages-nonzero-after-vacuum-or-analyze.patch) at 2020-07-24 22:34:45 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)

History

When	Who	What
2020-08-30 16:22:18	Tom Lane (tgl)	Closed in commitfest 2020-09 with status: Committed
2020-08-30 16:15:14	Tom Lane (tgl)	Added tgl as committer
2020-08-25 08:03:35	Pavel Stehule (okbobcz)	Added okbobcz as reviewer
2020-08-25 08:00:19	Pavel Stehule (okbobcz)	New status: Ready for Committer
2020-08-23 21:10:25	Tom Lane (tgl)	Changed authors to Tom Lane (tgl)
2020-08-23 21:10:09	Tom Lane (tgl)	Attached mail thread F02298E0-6EF4-49A1-BCB6-C484794D9ACC@thebuild.com
2020-08-23 21:10:09	Tom Lane (tgl)	Created patch record