Query size limitation missing in documentation

From: Martín Marqués <martin(dot)marques(at)gmail(dot)com>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Subject: Query size limitation missing in documentation
Date: 2021-11-15 16:58:45
Message-ID: CABeG9LsG1KYcEXaDDjFQgCiV2nDGfJtHDJauQ5gSbVt40U7s7g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

Hello,

I was looking at https://www.postgresql.org/docs/current/limits.html
(was brought up by a customer) and found we are missing the limitation
of the string of the SQL to be executed (it's 1GB which is the longest
string postgres can hold)

```
/* It's possible we could use a different value for this in frontend code */
#define MaxAllocSize ((Size) 0x3fffffff) /* 1 gigabyte - 1 */
```

Would there be any objections to adding such limitations in the list
from the link above?

Attached in a proposed patch which adds this to the documentation. I
also added a paragraph mentioning why the field and query length are
limited by 1GB.

--
Martín Marqués
It’s not that I have something to hide,
it’s that I have nothing I want you to see

Attachment Content-Type Size
Add-query-length-limit.patch text/x-patch 795 bytes

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Tom Lane 2021-11-15 17:07:54 Re: Query size limitation missing in documentation
Previous Message Laurenz Albe 2021-11-15 15:25:33 Re: Error in sample on doc page