Document parameter count limit - Mailing list pgsql-hackers

From David G. Johnston
Subject Document parameter count limit
Date
Msg-id CAKFQuwYeNPxeocV3_0+Zx=_Xwvg+sNyEMdzyG5s2E2e0hZLQhg@mail.gmail.com
Whole thread Raw
Responses Re: Document parameter count limit
List 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.

pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: Out-of-date clang/llvm version lists in PGAC_LLVM_SUPPORT
Next
From: Andres Freund
Date:
Subject: Re: heavily contended lwlocks with long wait queues scale badly