Postgres Pro
Downloads
Home   >   mailing lists

Re: Recursive query - ERROR: invalid memory alloc request size 1073741824 - Mailing list pgsql-sql

From Rob Sargent
Subject Re: Recursive query - ERROR: invalid memory alloc request size 1073741824
Date
Msg-id 014bdb01-07d9-1d03-24a1-2588dec64843@gmail.com
Whole thread Raw
In response to Recursive query - ERROR: invalid memory alloc request size 1073741824  (Shaozhong SHI <shishaozhong@gmail.com>)
List pgsql-sql
Tree view
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 230. 

pgsql-sql by date:

Previous
From: Shaozhong SHI
Date:
Subject: Recursive query - ERROR: invalid memory alloc request size 1073741824
Next
From: "David G. Johnston"
Date:
Subject: Re: Ignore error and carry on