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 (1 year, 11 months ago)

Latest email

2022-10-11 06:48:24 (1 year, 11 months ago)

Status

2022-11: Committed

Target version

Authors

Tom Lane (tgl)

Reviewers

Nathan Bossart (bossartn)Become reviewer

Committer

Tom Lane (tgl)

Links

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