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
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
[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])