From: rob stone <floriparob@gmail.com>
To: PegoraroF10 <marcos@f10.com.br>
To: pgsql-general@postgresql.org
Subject: Re: Server goes to Recovery Mode when run a SQL
Date: Wed, 13 Feb 2019 23:29:37 +1100
Message-ID: <b81253019232ee9a6a720c7f6530164ab6c68639.camel@gmail.com> (raw)
In-Reply-To: <1550058083109-0.post@n3.nabble.com>
References: <1549209182255-0.post@n3.nabble.com>
<1549209942200-0.post@n3.nabble.com>
<1549660293178-0.post@n3.nabble.com>
<20190209214651.GP31721@telsasoft.com>
<b89edc1e814863db892ba74332ad6ccaf4eccc9f.camel@gmail.com>
<20190212032432.GH1475@paquier.xyz>
<1550058083109-0.post@n3.nabble.com>
Hello Marcos,
On Wed, 2019-02-13 at 04:41 -0700, PegoraroF10 wrote:
> Here is a SQL which will get that recovery mode. You can run it on
> any database because we created it with FROM VALUES, so ...
> But this one is that one which grows and grows memory use until all
> memory and swap space are gone, so problem occurs. That other SQL
> which gives us the same problem but immediatelly we couldn´t replay
> it without our entire database. Even if we extract just that schema
> to a new DB it doesn´t go to recovery mode. We will think a little
> bit more to create something you can test.
>
Thanks for the revised query.
However, the create table/view scripts are needed as well.
Cheers,
Robert
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: pgsql-general@postgresql.org
Cc: floriparob@gmail.com, marcos@f10.com.br
Subject: Re: Server goes to Recovery Mode when run a SQL
In-Reply-To: <b81253019232ee9a6a720c7f6530164ab6c68639.camel@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 DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox