Re: SQL Request Size

Поиск
Список
Период
Сортировка
От Hannu Krosing
Тема Re: SQL Request Size
Дата
Msg-id 1116277717.4965.3.camel@fuji.krosing.net
обсуждение исходный текст
Ответ на SQL Request Size  (Simon Riggs <simon@2ndquadrant.com>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: bitmap scans, btree scans, and tid order
Следующее
От: Tom Lane
Дата:
Сообщение: Re: performance of bitmap scans in nested loop joins