Use syscache to do lookups in pg

Use syscache to do lookups in pg_extension

Title

Use syscache to do lookups in pg_extension

Topic

Performance

Created

2024-09-05 20:52:17

Last modified

2024-09-07 11:44:46 (2 months, 1 week ago)

Latest email

2024-09-07 11:44:20 (2 months, 1 week ago)

Status

2024-11: Committed

Target version

Authors

Andrei Lepikhov (lepikhov)

Reviewers

Jelte Fennema-Nio (jeltef)Become reviewer

Committer

Michael Paquier (michael-kun)

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/5241
git checkout commitfest/cf/5241

Emails

Create syscaches for pg_extension: First at 2024-08-13 14:12:57 by Jelte Fennema-Nio <postgres at jeltef.nl>
Latest at 2024-09-07 11:44:20 by Michael Paquier <michael at paquier.xyz>
Latest attachment (0001-Lookup-an-extension-data-in-corresponding-syscache.patch) at 2024-09-05 20:03:09 from Andrei Lepikhov <lepihov at gmail.com>
    Attachment (0001-Lookup-an-extension-data-in-corresponding-syscache.patch) at 2024-09-05 20:03:09 from Andrei Lepikhov <lepihov at gmail.com> (Patch: Yes)
    Attachment (0001-Use-EXTENSIONNAME-syscache-to-find-extension-oid.patch) at 2024-09-05 13:41:19 from Andrei Lepikhov <lepihov at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Create-syscaches-for-pg_extension.patch) at 2024-08-13 14:12:57 from Jelte Fennema-Nio <postgres at jeltef.nl> (Patch: Yes)

History

When	Who	What
2024-09-07 11:44:46	Michael Paquier (michael-kun)	Closed in commitfest 2024-11 with status: Committed
2024-09-05 23:29:09	Michael Paquier (michael-kun)	Added michael-kun as committer
2024-09-05 20:55:19	Jelte Fennema-Nio (jeltef)	New status: Ready for Committer
2024-09-05 20:52:44	Jelte Fennema-Nio (jeltef)	Changed reviewers to Jelte Fennema-Nio (jeltef)
2024-09-05 20:52:44	Jelte Fennema-Nio (jeltef)	Changed authors to Andrei Lepikhov (lepikhov)
2024-09-05 20:52:44	Jelte Fennema-Nio (jeltef)	Changed targetversion to 18
2024-09-05 20:52:17	Jelte Fennema-Nio (jeltef)	Attached mail thread CAGECzQTWm9sex719Hptbq4j56hBGUti7J9OWjeMobQ1ccRok9w@mail.gmail.com
2024-09-05 20:52:17	Jelte Fennema-Nio (jeltef)	Created patch record