Fix bloat in standby's list of exclusive locks held upstream

Title

Topic

Performance

Created

2022-10-04 22:57:05

Last modified

2022-10-06 16:28:01 (2 years, 1 month ago)

Latest email

2022-10-11 06:48:24 (2 years, 1 month ago)

Status

2022-11: Committed

Target version

Authors

Tom Lane (tgl)

Reviewers

Nathan Bossart (bossartn)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/3930
git checkout commitfest/cf/3930

Emails

Startup process on a hot standby crashes with an error "invalid memory alloc request size 1073741824" while replaying "Standby/LOCK" records: First at 2022-09-05 10:19:58 by Dmitriy Kuzmin <kuzmin.db4 at gmail.com>
Latest at 2022-10-11 06:48:24 by Kyotaro Horiguchi <horikyota.ntt at gmail.com>
Latest attachment (startup-stats.patch) at 2022-10-05 15:30:22 from Tom Lane <tgl at sss.pgh.pa.us>
    Attachment (startup-stats.patch) at 2022-10-05 15:30:22 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (fix-RecoveryLockLists-data-structure-2.patch) at 2022-10-04 23:53:11 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (fix-RecoveryLockLists-data-structure-1.patch) at 2022-10-04 22:54:08 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (950k_locks.sql) at 2022-09-05 10:19:58 from Dmitriy Kuzmin <kuzmin.db4 at gmail.com> (Patch: No)

History

When	Who	What
2022-10-06 16:28:01	Tom Lane (tgl)	Closed in commitfest 2022-11 with status: Committed
2022-10-06 16:28:01	Tom Lane (tgl)	Changed committer to tgl
2022-10-05 00:25:20	Nathan Bossart (bossartn)	Added bossartn as reviewer
2022-10-04 22:57:11	Tom Lane (tgl)	Changed authors to Tom Lane (tgl)
2022-10-04 22:57:05	Tom Lane (tgl)	Attached mail thread CAHLDt=_ts0A7Agn=hCpUh+RCFkxd+G6uuT=kcTfqFtGur0dp=A@mail.gmail.com
2022-10-04 22:57:05	Tom Lane (tgl)	Created patch record