Horton

Re: SQL Request Size

Hannu Krosing <hannu@tm.ee>

View thread
From: Hannu Krosing <hannu@tm.ee>
To: Simon Riggs <simon@2ndquadrant.com>
Cc: pgsql-hackers@postgresql.org
Date: 2005-05-16T21:08:37Z
Lists: pgsql-hackers 
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>