RE: query length limits

Well, this is what I have discovered so far:

I left BLCKSZ as it was, but adjusted MAX_QUERY_SIZE to 65535, and ran make.
I tried to run a 50k query, and it worked; it took a while, but the results
were fine.  So, as a temporary solution to this problem, you should be able
to set MAX_QUERY_SIZE up to what you require (don't go overboard, and please
let me know of any problems).  However, make sure that you test it properly
first, because I didn't do extensive testing, just enough to make sure that
it didn't break immediately.  Also, please remember that long queries
definitely impact the query processor, so long queries are not a great idea
for online sub-systems.  They're not great for batch either, but at least
there you have a window to play with.

More news to come.....

MikeA



>> > 
>> > Troy wrote:
>> > >>  Does Postgres have any limitations on 
>> > >>  the length of queries?
>> > >>  
>> > >>  E.g. is "select one,two,three,...thousand from 
>> one,two,three,...thousand
>> > where one = x and two is >>  x and three is x and ... 
>> thousand = x" legal?
>> > >>  
>> > Yes, there is.  It is set to BLCKSZ * 2, at least in 6.5.  
>> BLCKSZ is
>> > normally 8192 bytes, so your query size will be 16k.  
>> However, I'm busy
>> > working on it at the moment, to make it unlimited (i.e.: 
>> limited by memory
>> > available).
>> > 
>> > MikeA
>> > 
>> > 
>>