Re: long transactions / backend memory usage

On 11/26/2015 06:35 AM, krichy(at)tvnetwork(dot)hu wrote:
> Dear all,
>
> 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.

To make this repeatable can you show the command you are using to
measure memory usage?

>
> This can be reproduced on 9.3 and 9.4 also.
>
> Thanks in advance,
> Kojedzinszky Richárd
> Euronet Magyarorszag Informatika Zrt.
>
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com