public inbox for [email protected]  

help / color / mirror / Atom feed

From: Simon Riggs <[email protected]>
To: Shaozhong SHI <[email protected]>
Cc: pgsql-sql <[email protected]>
Subject: Re: Recursive query - ERROR: invalid memory alloc request size 1073741824
Date: Sun, 8 May 2022 20:15:54 +0100
Message-ID: <CANbhV-EXLBNR00HGOcxTi2Qoc-9aYmg5SG9a3C8hPqGYGJ0X5w@mail.gmail.com> (raw)
In-Reply-To: <CA+i5JwZ85nr+EBRn4PT9N=V1outgJ7OFBe5VVGoP6bmguC7Bog@mail.gmail.com>
References: <CA+i5Jwa-8rhDTvg=q+Sox0H7+Gr+NVTO=67=Ch3hQZuZO6TnkQ@mail.gmail.com>
	<CA+i5JwZ85nr+EBRn4PT9N=V1outgJ7OFBe5VVGoP6bmguC7Bog@mail.gmail.com>

On Sat, 7 May 2022 at 14:24, Shaozhong SHI <[email protected]> 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/

view thread (4+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Recursive query - ERROR: invalid memory alloc request size 1073741824
  In-Reply-To: <CANbhV-EXLBNR00HGOcxTi2Qoc-9aYmg5SG9a3C8hPqGYGJ0X5w@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox