Message-ID: <543C1DBA.4020805@web.de>
Date: Mon, 13 Oct 2014 20:45:14 +0200
From: Jan Lentfer <Jan.Lentfer@web.de>
User-Agent: Mozilla/5.0 (X11; Linux i686;
 rv:31.0) Gecko/20100101 Thunderbird/31.1.2
MIME-Version: 1.0
To: =?UTF-8?B?RWzDrWFzIERhdmlk?= <elias.moreno.tec@gmail.com>,
 pgsql-admin@postgresql.org
Subject: Re: PostgreSQL 9.3 abd CentOS 7 memory usage
References: 
 <CANNE3r3jr2-sSH4QTj4TufPKYGry0=hORvZr95wHSu1yC1JneQ@mail.gmail.com>
 <DBB15467-01FA-45EF-917A-023C3DCBC02A@web.de>
 <CANNE3r0zMxOszsj-qPqgQdpgUFWcTPi1dJ+1fZTOq=ZdpRzjdw@mail.gmail.com>
In-Reply-To: 
 <CANNE3r0zMxOszsj-qPqgQdpgUFWcTPi1dJ+1fZTOq=ZdpRzjdw@mail.gmail.com>
Content-Type: multipart/alternative;
 boundary="------------020509020605040906000404"
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

This is a multi-part message in MIME format.
--------------020509020605040906000404
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable


Am 13.10.2014 um 20:12 schrieb El=C3=ADas David:

>> What's the on-disk size of your databases and can you estimate the
actual working set? How long is this system up and being queried?

    >> I have seen similar when upgrading from 8.4 to 9.3 on Solaris 10,
    Postgres running in zones. I could not yet investigate further and
    performance is perfect still.


> Ok, here it goes:
>
> ccs1cl --> 41 MB
> db_otrs_ub --> 14 MB
> elmap --> 207 MB
> elmap_int --> 182 MB
> invent_equi --> 532 MB
> invent_equi_fc --> 114 MB
> jasper --> 13 MB
> netasis --> 23 MB
> otrs --> 361 MB
> patint --> 615 MB
> seg_alt --> 75 MB
> seg_alt_par --> 75 MB
>
> The average of transactions are around 85 per second and several of
> the databases (jasper, patint, elmap...) are accessed everyday, 365
> days a year (it's part of an offering from the company that runs the
> services every single day of the year). Right now the system has been
> up for 17 days.
>

So, that sums up to 2,2GB of databases (is that the right unit? MB?) ...
so even IF all of the data was read and stored in buffers that would not
cause a significant amount of memory used data on a 128GB machine, When
you look at "top" output, what the value for "cached" (5th line on the
very right)?

--------------020509020605040906000404
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: quoted-printable

<html>
  <head>
    <meta content=3D"text/html; charset=3Dutf-8" http-equiv=3D"Content-Ty=
pe">
  </head>
  <body bgcolor=3D"#FFFFFF" text=3D"#000000">
    <div class=3D"moz-cite-prefix"><br>
      <br>
      Am 13.10.2014 um 20:12 schrieb El=C3=ADas David:<br>
      <br>
      <div class=3D"gmail_quote">&gt;&gt; What's the on-disk size of your
        databases and can you estimate the actual working set? How long
        is this system up and being queried?<br>
        <blockquote class=3D"gmail_quote" style=3D"margin:0 0 0
          .8ex;border-left:1px #ccc solid;padding-left:1ex">&gt;&gt; I
          have seen similar when upgrading from 8.4 to 9.3 on Solaris
          10, Postgres running in zones. I could not yet investigate
          further and performance is perfect still.<br>
        </blockquote>
      </div>
      <br>
    </div>
    <blockquote
cite=3D"mid:CANNE3r0zMxOszsj-qPqgQdpgUFWcTPi1dJ+1fZTOq=3DZdpRzjdw@mail.gm=
ail.com"
      type=3D"cite">
      <div dir=3D"ltr">Ok, here it goes:
        <div><br>
        </div>
        <div>ccs1cl --&gt; 41 MB</div>
        <div>db_otrs_ub --&gt; 14 MB</div>
        <div>elmap --&gt;=C2=A0207 MB</div>
        <div>elmap_int --&gt;=C2=A0182 MB<br>
        </div>
        <div>invent_equi --&gt;=C2=A0532 MB<br>
        </div>
        <div>invent_equi_fc --&gt;=C2=A0114 MB<br>
        </div>
        <div>jasper --&gt;=C2=A013 MB<br>
        </div>
        <div>netasis --&gt;=C2=A023 MB<br>
        </div>
        <div>otrs --&gt;=C2=A0361 MB<br>
        </div>
        <div>patint --&gt;=C2=A0615 MB<br>
        </div>
        <div>seg_alt --&gt;=C2=A075 MB<br>
        </div>
        <div>seg_alt_par --&gt;=C2=A075 MB<br>
        </div>
        <div><br>
        </div>
        <div>The average of transactions are around 85 per second and
          several of the databases (jasper, patint, elmap...) are
          accessed everyday, 365 days a year (it's part of an offering
          from the company that runs the services every single day of
          the year). Right now the system has been up for 17 days.</div>
        <div><br>
        </div>
        <div></div>
      </div>
    </blockquote>
    <br>
    So, that sums up to 2,2GB of databases (is that the right unit? MB?)
    ... so even IF all of the data was read and stored in buffers that
    would not cause a significant amount of memory used data on a 128GB
    machine, When you look at "top" output, what the value for "cached"
    (5th line on the very right)?<br>
  </body>
</html>

--------------020509020605040906000404--