[postgis-users] Recursive query - ERROR: invalid memory alloc request size 1073741824

[Imre Samu]

Hi David,
> There is a loop of recursive query.  It runs at a point where it stops.
>Can anyone provide pointers how to solve this problem or work around?

Please share "this" recursive query;

My guess:  Probably you have a "forever/endless loop" in your data; *so you
have to LIMIT the recursive part ;*

related links :
1.)  with limiting "depth"   ( where depth < 1000 )
"Prevent infinite loop in recursive query in Postgresql"
https://stackoverflow.com/questions/51025607/prevent-infinite-loop-in-recursive-query-in-postgresql
2.)  with LIMITING clause
https://www.cybertec-postgresql.com/en/recursive-queries-postgresql/
*"This example also demonstrates how an endless loop can be avoided with a
LIMIT clause on the parent query."*

Regards,
  Imre

Shaozhong SHI <shishaozhong at gmail.com> ezt írta (időpont: 2022. máj. 7.,
Szo, 15:23):

> 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?
>
> Regards,
>
> David
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20220508/d73de678/attachment.htm>