Avoid O(N^2) script parsing cost in pgbench

Title

CI (CFBot)

Summary

Stats (from CFBot)

Patch version: v2, Patch count: 2, First patch: +93−60, All patches: +98−66

Topic

Performance

Created

2025-02-25 21:53:37

Last modified

2025-02-27 16:02:18 (1 month ago)

Latest email

2025-02-27 16:00:22 (1 month ago)

Status

2025-03: Committed

Target version

Authors

Tom Lane (tgl)

Reviewers

Committer

Tom Lane (tgl)

Links

Emails

pgbench client-side performance issue on large scripts: First at 2025-02-24 19:52:44 by "Daniel Verite" <daniel at manitou-mail.org>
Latest at 2025-02-27 16:00:22 by Tom Lane <tgl at sss.pgh.pa.us>
Latest attachment (v2-0001-Get-rid-of-O-N-2-script-parsing-overhead-in-pgben.patch) at 2025-02-26 00:17:53 from Tom Lane <tgl at sss.pgh.pa.us>
    Attachment (v2-0001-Get-rid-of-O-N-2-script-parsing-overhead-in-pgben.patch) at 2025-02-26 00:17:53 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: No)
    Attachment (v1-0001-Get-rid-of-O-N-2-script-parsing-overhead-in-pgben.patch) at 2025-02-25 21:52:08 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: No)
    Attachment (pgbench-lineno-perf-fix.patch) at 2025-02-24 19:52:44 from "Daniel Verite" <daniel at manitou-mail.org> (Patch: Yes)

History

When	Who	What
2025-02-27 16:02:18	Tom Lane (tgl)	Closed in commitfest 2025-03 with status: Committed
2025-02-27 16:02:18	Tom Lane (tgl)	Changed committer to tgl
2025-02-25 21:54:00	Tom Lane (tgl)	Changed authors to Tom Lane (tgl)
2025-02-25 21:53:37	Tom Lane (tgl)	Attached mail thread 84a8a89e-adb8-47a9-9d34-c13f7150ee45@manitou-mail.org
2025-02-25 21:53:37	Tom Lane (tgl)	Created patch record