why postgres process takes so much memory during day time

From: Marcin Giedz <marcin(dot)giedz(at)arise(dot)pl>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: why postgres process takes so much memory during day time
Date: 2019-09-13 09:37:51
Message-ID: 2134230905.1198322.1568367471812.JavaMail.zimbra@arise.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all, is there any way to figure out why particular postgres process takes more and more memory during the day? This process performes order data queries coming from order management system - exchange system. Normally it's about 0,5mln messages per day but after aprox 4h postgres process occupies :

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
11920 pgsql 20 0 17,6g 9,7g 566572 S 2,6 10,4 2:40.47 postgres

Perhaps dev guys (our team) should change something inside our system or it's postgresql conf matter? Postgres engine is 9.6.7. Any hint on this please?

Thx
Marcin

Browse pgsql-general by date

  From Date Subject
Next Message stan 2019-09-13 09:57:33 How to handle things that change over time?
Previous Message Peter J. Holzer 2019-09-13 07:39:19 Re: Referncing a calculated column in a select?