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

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/