[HACKERS] 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 ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [HACKERS] SQL Request Size
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 [EMAIL PROTECTED] ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [HACKERS] SQL Request Size
Simon Riggs [EMAIL PROTECTED] 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 ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly