From: | Kojedzinszky Richárd <kojedzinszky(dot)richard(at)euronetrt(dot)hu> |
---|---|
To: | Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: long transactions / backend memory usage |
Date: | 2015-11-26 15:58:25 |
Message-ID: | alpine.DEB.2.20.1511261653500.10745@krichy.tvnetwork.hu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(dot)Hilbert(at)gmx(dot)net>
> To: pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] long transactions / backend memory usage
>
> On Thu, Nov 26, 2015 at 03:35:49PM +0100, krichy(at)tvnetwork(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
From | Date | Subject | |
---|---|---|---|
Next Message | krichy | 2015-11-26 15:59:56 | Re: long transactions / backend memory usage |
Previous Message | Adrian Klaver | 2015-11-26 15:47:33 | Re: Convert from hex to string |