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 →
  1. Document limit on the number of out-of-line values per table

  2. Log when GetNewOidWithIndex() fails to find unused OID many times.