Re: long transactions / backend memory usage - Mailing list pgsql-general

From Kojedzinszky Richárd
Subject Re: long transactions / backend memory usage
Date
Msg-id alpine.DEB.2.20.1511261653500.10745@krichy.tvnetwork.hu
Whole thread Raw
In response to Re: long transactions / backend memory usage  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
List pgsql-general
Do you mean the scripting language? Originally we use C++ code with tntdb
(from http://www.tntnet.org/) with the same symptons/issues.

I dont think that counts.

Thanks,

Kojedzinszky Richárd
Euronet Magyarorszag Informatika Zrt.

On Thu, 26 Nov 2015, Karsten Hilbert wrote:

> Date: Thu, 26 Nov 2015 15:41:06 +0100
> From: Karsten Hilbert <Karsten.Hilbert@gmx.net>
> To: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] long transactions / backend memory usage
>
> On Thu, Nov 26, 2015 at 03:35:49PM +0100, krichy@tvnetwork.hu wrote:
>
>> We have run into a case where we run a long transaction, and during the
>> transaction the backend process's memory usage is growing constantly.
>>
>> I've written a script to simulate this, please someone confirm if it is
>> normal or not.
>>
>> The script just inserts and removes rows in a table in a single transaction.
>> If given a parameter, the same row is being inserted and removed.
>>
>> The latter case also produces constantly increasing backend process memory
>> usage.
>>
>> Create the table as in the script, and after run:
>>
>> $ perl pqtest.pl 5
>>
>> I've been running the script for nearly 40 minutes right now, it has done
>> 120k iterations, and the RSS of the postgresql process is still growing.
>>
>> This can be reproduced on 9.3 and 9.4 also.
>
> Can it be reproduced when implemented in another language, too ?
>
> Karsten
> --
> GPG key ID E4071346 @ eu.pool.sks-keyservers.net
> E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

pgsql-general by date:

Previous
From: Ramesh T
Date:
Subject: Re: Taking lot time
Next
From: mrtruji
Date:
Subject: Selecting newly added column returns empty but only when selecting with other columns in table