Re: SQL Request Size - Mailing list pgsql-hackers

From Hannu Krosing
Subject Re: SQL Request Size
Date
Msg-id 1116277717.4965.3.camel@fuji.krosing.net
Whole thread Raw
In response to SQL Request Size  (Simon Riggs <simon@2ndquadrant.com>)
List 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>


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: bitmap scans, btree scans, and tid order
Next
From: Tom Lane
Date:
Subject: Re: performance of bitmap scans in nested loop joins