Document parameter count limit

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Document parameter count limit
Date: 2022-11-10 00:34:26
Message-ID: CAKFQuwYeNPxeocV3_0+Zx=_Xwvg+sNyEMdzyG5s2E2e0hZLQhg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Inspired by a recent posting on Slack...

diff --git a/doc/src/sgml/limits.sgml b/doc/src/sgml/limits.sgml
index d5b2b627dd..5d68eef093 100644
--- a/doc/src/sgml/limits.sgml
+++ b/doc/src/sgml/limits.sgml
@@ -97,6 +97,13 @@
<entry>32</entry>
<entry>can be increased by recompiling
<productname>PostgreSQL</productname></entry>
</row>
+
+ <row>
+ <entry>parameters per query</entry>
+ <entry>65,535</entry>
+ <entry>if you are reading this prepatorily, please redesign your query
to use temporary tables or arrays</entry>
+ </row>
+
</tbody>
</tgroup>
</table>

David J.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2022-11-10 01:03:13 Re: heavily contended lwlocks with long wait queues scale badly
Previous Message Andres Freund 2022-11-10 00:25:48 Re: Out-of-date clang/llvm version lists in PGAC_LLVM_SUPPORT