Replace spinlock with lwlock in pg_stat

Replace spinlock with lwlock in pg_stat_statements

Title

Replace spinlock with lwlock in pg_stat_statements

Topic

Performance

Created

2020-07-03 02:43:36

Last modified

2020-09-30 07:10:26 (4 years, 1 month ago)

Latest email

2020-09-30 07:11:55 (4 years, 1 month ago)

Status

2020-09: Returned with feedback

Target version

Authors

Fujii Masao (masaofujii)

Reviewers

Hamid Akhtar (hamidakhtar)Become reviewer

Committer

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

Emails

track_planning causing performance regression: First at 2020-06-29 05:48:35 by "Tharakan, Robins" <tharar at amazon.com>
Latest at 2020-09-30 07:11:55 by Michael Paquier <michael at paquier.xyz>
Latest attachment (pgss_lwlock_v2.patch) at 2020-08-18 15:43:49 from Fujii Masao <masao.fujii at oss.nttdata.com>
    Attachment (pgss_lwlock_v2.patch) at 2020-08-18 15:43:49 from Fujii Masao <masao.fujii at oss.nttdata.com> (Patch: Yes)
    Attachment (document_overhead_by_track_planning.patch) at 2020-07-03 11:02:03 from Fujii Masao <masao.fujii at oss.nttdata.com> (Patch: Yes)
    Attachment (pgss_lwlock_v1.patch) at 2020-06-30 05:43:39 from Fujii Masao <masao.fujii at oss.nttdata.com> (Patch: Yes)
    Attachment (futex-prototype.patch) at 2020-06-29 13:23:41 from Ants Aasma <ants at cybertec.at> (Patch: Yes)
    Attachment (disable_pgss_planning_default_v1.patch) at 2020-06-29 11:14:34 from Fujii Masao <masao.fujii at oss.nttdata.com> (Patch: Yes)

History

When	Who	What
2020-09-30 07:10:26	Michael Paquier (michael-kun)	Closed in commitfest 2020-09 with status: Returned with feedback
2020-08-19 12:45:41	Hamid Akhtar (hamidakhtar)	Posted review with messageid <159784114193.7095.7438157679688812860.pgcf@coridan.postgresql.org>
2020-08-19 12:45:41	Hamid Akhtar (hamidakhtar)	New status: Waiting on Author
2020-08-17 16:40:00	Hamid Akhtar (hamidakhtar)	Added hamidakhtar as reviewer
2020-08-17 09:31:24	Hamid Akhtar (hamidakhtar)	Removed hamidakhtar from reviewers
2020-08-17 09:29:12	Hamid Akhtar (hamidakhtar)	Added hamidakhtar as reviewer
2020-07-31 12:39:46	Hamid Akhtar (hamidakhtar)	Removed hamidakhtar from reviewers
2020-07-13 18:26:16	Hamid Akhtar (hamidakhtar)	Added hamidakhtar as reviewer
2020-07-03 02:43:51	Fujii Masao (masaofujii)	Changed authors to Fujii Masao (masaofujii)
2020-07-03 02:43:36	Fujii Masao (masaofujii)	Attached mail thread 2895b53b033c47ccb22972b589050dd9@EX13D05UWC001.ant.amazon.com
2020-07-03 02:43:36	Fujii Masao (masaofujii)	Created patch record