RE: query length limits - Mailing list pgsql-sql

From Ansley, Michael
Subject RE: query length limits
Date
Msg-id 1BF7C7482189D211B03F00805F8527F70ED043@S-NATH-EXCH2
Whole thread Raw
In response to query length limits  ("tjk@tksoft.com" <tk@uno.tksoft.com>)
List pgsql-sql
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



pgsql-sql by date:

Previous
From: "tjk@tksoft.com"
Date:
Subject: query length limits
Next
From: Michael Richards
Date:
Subject: Re: [HACKERS] Counting bool flags in a complex query