On Thu, Nov 26, 2015 at 03:35:49PM +0100, krichy@xxxxxxxxxxxx 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
