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

From Adrian Klaver
Subject Re: long transactions / backend memory usage
Date
Msg-id 5657379E.5040104@aklaver.com
Whole thread Raw
In response to long transactions / backend memory usage  (krichy@tvnetwork.hu)
List pgsql-general
On 11/26/2015 06:35 AM, krichy@tvnetwork.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.
>
> This can be reproduced on 9.3 and 9.4 also.

Also what minor versions for the above?

>
> Thanks in advance,
> Kojedzinszky Richárd
> Euronet Magyarorszag Informatika Zrt.
>
>
>


--
Adrian Klaver
adrian.klaver@aklaver.com


pgsql-general by date:

Previous
From: Karsten Hilbert
Date:
Subject: Re: long transactions / backend memory usage
Next
From: Tom Lane
Date:
Subject: Re: long transactions / backend memory usage