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