Re: Recursive query - ERROR: invalid memory alloc request size 1073741824

From: Rob Sargent <robjsargent(at)gmail(dot)com>
To: pgsql-sql(at)lists(dot)postgresql(dot)org
Subject: Re: Recursive query - ERROR: invalid memory alloc request size 1073741824
Date: 2022-05-07 13:53:11
Message-ID: 014bdb01-07d9-1d03-24a1-2588dec64843@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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 .

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message David G. Johnston 2022-05-07 14:38:26 Re: Ignore error and carry on
Previous Message Shaozhong SHI 2022-05-07 13:23:53 Recursive query - ERROR: invalid memory alloc request size 1073741824