| From: | Michael Paquier <michael(at)paquier(dot)xyz> |
|---|---|
| To: | Nathan Bossart <nathandbossart(at)gmail(dot)com> |
| Cc: | "Jonathan S(dot) Katz" <jkatz(at)postgresql(dot)org>, Andres Freund <andres(at)anarazel(dot)de>, Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org, Thomas Munro <thomas(dot)munro(at)gmail(dot)com>, Yura Sokolov <y(dot)sokolov(at)postgrespro(dot)ru> |
| Subject: | Re: heavily contended lwlocks with long wait queues scale badly |
| Date: | 2024-01-11 03:45:12 |
| Message-ID: | ZZ9kSJP7fX4RP173@paquier.xyz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Wed, Jan 10, 2024 at 09:17:47PM -0600, Nathan Bossart wrote:
> Now that commit a4adc31 has had some time to bake and concerns about
> unintended consequences may have abated, I wanted to revive this
> back-patching discussion. I see a few possibly-related reports [0] [1]
> [2], and I'm now seeing this in the field, too. While it is debatable
> whether this is a bug, it's a quite nasty issue for users, and it's both
> difficult to detect and difficult to work around.
+1, I've seen this becoming a PITA for a few things. Knowing that the
size of PGPROC does not change at all, I would be in favor for a
backpatch, especially since it's been in the tree for more than 1
year, and even more knowing that we have 16 released with this stuff
in.
--
Michael
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dian Fay | 2024-01-11 03:57:33 | Re: add function argument names to regex* functions. |
| Previous Message | Michael Paquier | 2024-01-11 03:40:35 | Re: pg_ctl start may return 0 even if the postmaster has been already started on Windows |