Re: [HACKERS] MAX Query length

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [HACKERS] MAX Query length
Дата
Msg-id 25865.931968128@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [HACKERS] MAX Query length  (Bernard Frankpitt <frankpit@pop.dn.net>)
Ответы Re: [HACKERS] MAX Query length  (wieck@debis.com (Jan Wieck))
Список pgsql-hackers
Bernard Frankpitt <frankpit@pop.dn.net> writes:
> Tom Lane wrote:
>> Sure: you want to be able to INSERT a tuple of maximum size.  In the
>> absence of dynamically sized text buffers, a reasonable estimate of
>> the longest INSERT command of interest is going to depend on BLCKSZ.

> Perhaps it would be a good idea to increase
> the multiplier in 
>     #define MAX_QUERY_SIZE (BLCKSZ * 2)
> to something larger than 2.

This entire chain of logic will fall to the ground anyway once we support
tuples larger than a disk block, which I believe is going to happen
before too much longer.  So, rather than argue about what the multiplier
ought to be, I think it's more productive to just press on with making
the query buffers dynamically resizable...
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Arrays versus 'type constant' syntax
Следующее
От: Lamar Owen
Дата:
Сообщение: Password redux (was:Re: [HACKERS] Updated TODO list)