From: Jan Lentfer <Jan.Lentfer@web.de>
To: Elías David <elias.moreno.tec@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: PostgreSQL 9.3 abd CentOS 7 memory usage
Date: Mon, 13 Oct 2014 20:45:14 +0200
Message-ID: <543C1DBA.4020805@web.de> (raw)
In-Reply-To: <CANNE3r0zMxOszsj-qPqgQdpgUFWcTPi1dJ+1fZTOq=ZdpRzjdw@mail.gmail.com>
References: <CANNE3r3jr2-sSH4QTj4TufPKYGry0=hORvZr95wHSu1yC1JneQ@mail.gmail.com>
<DBB15467-01FA-45EF-917A-023C3DCBC02A@web.de>
<CANNE3r0zMxOszsj-qPqgQdpgUFWcTPi1dJ+1fZTOq=ZdpRzjdw@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Am 13.10.2014 um 20:12 schrieb Elías 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)?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: Jan.Lentfer@web.de, elias.moreno.tec@gmail.com
Subject: Re: PostgreSQL 9.3 abd CentOS 7 memory usage
In-Reply-To: <543C1DBA.4020805@web.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox