Content-Type: multipart/alternative;
 boundary="------------ytxvr6eQHZyvbj8FfFAAFPgS"
Message-ID: <014bdb01-07d9-1d03-24a1-2588dec64843@gmail.com>
Date: Sat, 7 May 2022 07:53:11 -0600
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:91.0) Gecko/20100101
 Thunderbird/91.8.1
Subject: Re: Recursive query - ERROR: invalid memory alloc request size
 1073741824
Content-Language: en-CA
To: pgsql-sql@lists.postgresql.org
References: 
 <CA+i5Jwa-8rhDTvg=q+Sox0H7+Gr+NVTO=67=Ch3hQZuZO6TnkQ@mail.gmail.com>
 <CA+i5JwZ85nr+EBRn4PT9N=V1outgJ7OFBe5VVGoP6bmguC7Bog@mail.gmail.com>
From: Rob Sargent <robjsargent@gmail.com>
In-Reply-To: 
 <CA+i5JwZ85nr+EBRn4PT9N=V1outgJ7OFBe5VVGoP6bmguC7Bog@mail.gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/014bdb01-07d9-1d03-24a1-2588dec64843%40gmail.com>
Precedence: bulk

This is a multi-part message in MIME format.
--------------ytxvr6eQHZyvbj8FfFAAFPgS
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit

On 5/7/22 07:23, Shaozhong SHI wrote:
> There is a loop of recursive query.  It runs at a point where it stops.
>
> This error turned up.- ERROR:  invalid memory alloc request size 
> 1,073,741,824
>
> Can anyone provide pointers how to solve this problem or work around?
>
> Regards,
>
> David
Quite difficult without any code snippet (or even which language) but 
you've requested a single block of memory that is larger than the 
maximum allowed. That number (1,073,741,824) is 2^30 .
--------------ytxvr6eQHZyvbj8FfFAAFPgS
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <div class="moz-cite-prefix">On 5/7/22 07:23, Shaozhong SHI wrote:<br>
    </div>
    <blockquote type="cite"
cite="mid:CA+i5JwZ85nr+EBRn4PT9N=V1outgJ7OFBe5VVGoP6bmguC7Bog@mail.gmail.com">
      <meta http-equiv="content-type" content="text/html; charset=UTF-8">
      <div dir="ltr">
        <div class="gmail_quote">
          <div dir="ltr" class="gmail_attr">There is a loop of recursive
            query.  It runs at a point where it stops.<br>
          </div>
          <div dir="ltr">
            <div dir="ltr">
              <div><br>
              </div>
              <div>This error turned up.- ERROR:  invalid memory alloc
                request size 1,073,741,824</div>
              <div><br>
              </div>
              <div>Can anyone provide pointers how to solve this problem
                or work around?</div>
              <div><br>
              </div>
              <div>Regards,</div>
              <div><br>
              </div>
              <div>David</div>
            </div>
          </div>
        </div>
      </div>
    </blockquote>
    <font face="Courier New, Courier, monospace">Quite difficult without
      any code snippet (or even which language) but you've requested a
      single block of memory that is larger than the maximum allowed.</font> 
    That number (1,073,741,824) is 2<sup>30</sup>.  <br>
  </body>
</html>

--------------ytxvr6eQHZyvbj8FfFAAFPgS--