RE: query length limits

Поиск
Список
Период
Сортировка
От Ansley, Michael
Тема RE: query length limits
Дата
Msg-id 1BF7C7482189D211B03F00805F8527F70ED043@S-NATH-EXCH2
обсуждение исходный текст
Ответ на query length limits  ("tjk@tksoft.com" <tk@uno.tksoft.com>)
Список 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 по дате отправления:

Предыдущее
От: "tjk@tksoft.com"
Дата:
Сообщение: query length limits
Следующее
От: Michael Richards
Дата:
Сообщение: Re: [HACKERS] Counting bool flags in a complex query