Jan Wieck writes:
> On 12/20/2012 4:47 PM, Dimitri Fontaine wrote:
>> Tom Lane writes:
>>> The reason this fails is that you've got a half-megabyte source string,
>>> and each of the 11000 plans that are due to be created from it saves
>>> its own copy of the source string. Hence, 5500 megabytes
On 12/20/2012 4:47 PM, Dimitri Fontaine wrote:
Tom Lane writes:
The reason this fails is that you've got a half-megabyte source string,
and each of the 11000 plans that are due to be created from it saves
its own copy of the source string. Hence, 5500 megabytes needed just
for source strings.
Tom Lane writes:
> The reason this fails is that you've got a half-megabyte source string,
> and each of the 11000 plans that are due to be created from it saves
> its own copy of the source string. Hence, 5500 megabytes needed just
> for source strings.
>
> We could possibly fix this by inventin
On 20.12.2012 02:29, Tom Lane wrote:
> Tomas Vondra writes:
>> What it does:
>
>> 1) creates a simple table called "test" with one text column.
>
>> 2) creates a plpgsql function with one parameter, and all that function
>>does is passing the parameter to EXECUTE
>
>> 3) calls the function
Tomas Vondra writes:
> What it does:
> 1) creates a simple table called "test" with one text column.
> 2) creates a plpgsql function with one parameter, and all that function
>does is passing the parameter to EXECUTE
> 3) calls the function with a string containing many INSERTs into the
>