Re: [HACKERS] MAX Query length - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [HACKERS] MAX Query length
Date
Msg-id 25865.931968128@sss.pgh.pa.us
Whole thread Raw
In response to Re: [HACKERS] MAX Query length  (Bernard Frankpitt <frankpit@pop.dn.net>)
Responses Re: [HACKERS] MAX Query length
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Arrays versus 'type constant' syntax
Next
From: Lamar Owen
Date:
Subject: Password redux (was:Re: [HACKERS] Updated TODO list)