Обсуждение: Recursive query - ERROR: invalid memory alloc request size 1073741824

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

Shaozhong SHI <shishaozhong@gmail.com> writes:
> 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 1073741824

Might be a bug, but with no details it's impossible to tell.

https://wiki.postgresql.org/wiki/Guide_to_reporting_problems

            regards, tom lane

On Sat, 7 May 2022 at 14:24, Shaozhong SHI <shishaozhong@gmail.com> 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 1073741824
>
> Can anyone provide pointers how to solve this problem or work around?

For both recursive and non-recursive queries its possible to write a
query with mistakes in it that will run for a long time or run out of
resources.

Find the mistakes in your query by simplifying it.

-- 
Simon Riggs                http://www.EnterpriseDB.com/