Re: Server goes to Recovery Mode when run a SQL

From: rob stone <floriparob(at)gmail(dot)com>
To: PegoraroF10 <marcos(at)f10(dot)com(dot)br>, pgsql-general(at)postgresql(dot)org
Subject: Re: Server goes to Recovery Mode when run a SQL
Date: 2019-02-13 12:29:37
Message-ID: b81253019232ee9a6a720c7f6530164ab6c68639.camel@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message PegoraroF10 2019-02-13 12:32:27 Re: Server goes to Recovery Mode when run a SQL
Previous Message PegoraroF10 2019-02-13 11:41:23 Re: Server goes to Recovery Mode when run a SQL