long transactions / backend memory usage

From: krichy(at)tvnetwork(dot)hu
To: pgsql-general(at)postgresql(dot)org
Subject: long transactions / backend memory usage
Date: 2015-11-26 14:35:49
Message-ID: alpine.DEB.2.20.1511261529170.11364@krichy.tvnetwork.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

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

Attachment Content-Type Size
pqtest.pl text/x-perl 671 bytes

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Karsten Hilbert 2015-11-26 14:41:06 Re: long transactions / backend memory usage
Previous Message Sterpu Victor 2015-11-26 12:52:26 Re: ARRAY_AGG and ORDER