Thread

1. SQL Request Size

   Simon Riggs <simon@2ndquadrant.com> — 2005-05-16T20:18:45Z

   What is the maximum SQL statement length that the server will accept?
   
   The libpq message length identifier is 4 bytes, which indicates that the
   max length is 4GB. But thats not exactly the same thing...
   
   Most other systems have a SQL request size limit much smaller than this,
   though I can't find reference to this. 
   
   Thanks,
   
   Best Regards, Simon Riggs
   
   
   

2. Re: SQL Request Size

   Hannu Krosing <hannu@tm.ee> — 2005-05-16T21:08:37Z

   On E, 2005-05-16 at 21:18 +0100, Simon Riggs wrote:
   > What is the maximum SQL statement length that the server will accept?
   > 
   > The libpq message length identifier is 4 bytes, which indicates that the
   > max length is 4GB. But thats not exactly the same thing...
   > 
   > Most other systems have a SQL request size limit much smaller than this,
   > though I can't find reference to this. 
   
   I've had problems with a query generated by slony that was a few hundred
   kilobytes in size. It gave me "query too complex" error, probably
   overflow somewhere in planner/optimiser.
   
   -- 
   Hannu Krosing <hannu@tm.ee>
   
   

3. Re: SQL Request Size

   Tom Lane <tgl@sss.pgh.pa.us> — 2005-05-16T21:30:52Z

   Simon Riggs <simon@2ndquadrant.com> writes:
   > What is the maximum SQL statement length that the server will accept?
   
   There is no fixed limit, short of where you start to overflow memory
   and/or stack depth.
   http://archives.postgresql.org/pgsql-general/2001-02/msg00776.php
   
   			regards, tom lane