Re: Doc limitation update proposal: include out-of-line OID usage per TOAST-ed columns
John Naylor <johncnaylorls@gmail.com>
From: John Naylor <johncnaylorls@gmail.com>
To: Jakub Wartak <jakub.wartak@enterprisedb.com>
Cc: Robert Haas <robertmhaas@gmail.com>,
"Andrey M. Borodin" <x4mmm@yandex-team.ru>, John Naylor <john.naylor@enterprisedb.com>,
Nikita Malakhov <hukutoc@gmail.com>, Gurjeet Singh <gurjeet@singh.im>,
PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2024-08-12T04:01:57Z
Lists: pgsql-hackers
On Mon, May 20, 2024 at 5:43 PM Jakub Wartak <jakub.wartak@enterprisedb.com> wrote: > > On Tue, May 14, 2024 at 8:19 PM Robert Haas <robertmhaas@gmail.com> wrote: > > > > I looked at your version and wrote something that is shorter and > > doesn't touch any existing text. Here it is. > > Hi Robert, you are a real tactician here - thanks for whatever > references the original problem! :) I like this text as well. > Maybe just slight hint nearby > expensive (to me indicating a just a CPU problem?): > > finding an OID that is still free can become expensive -> > finding an OID that is still free can become expensive, thus > significantly increasing INSERT/UPDATE response time. > > ? (this potentially makes it easier in future to pinpoint the user's > problem to the this exact limitation; but feel free to ignore that too > as I'm not attached to any of those versions) Extra explicitness might be good. "Response time" seems like a networking concept, so possibly ", in turn slowing down INSERT/UPDATE statements." I'm inclined to commit that way in a couple days, barring further comments. PS: Sorry for the delay in looking at the latest messages
Commits
Same data as JSON:
GET /api/v1/messages/:b64id/commits
the thread's linked commits as JSON, with link sources.
API reference →
-
Document limit on the number of out-of-line values per table
- e51160fa0bab 15.9 landed
- dda341b32c88 14.14 landed
- c9aa6f4f86fc 13.17 landed
- 667401dd40c8 17.0 landed
- 5ff394503ce2 12.21 landed
- 4d93bbd4e0d4 18.0 landed
- 409be33c3136 16.5 landed
-
Log when GetNewOidWithIndex() fails to find unused OID many times.
- 7fbcee1b2d5f 14.0 cited