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 |
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 |