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 |
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 |