Thread: SQL Request Size

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

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>

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