PostgreSQL 9.3 abd CentOS 7 memory usage

From: Elías David <elias(dot)moreno(dot)tec(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: PostgreSQL 9.3 abd CentOS 7 memory usage
Date: 2014-10-12 17:33:18
Message-ID: CANNE3r3jr2-sSH4QTj4TufPKYGry0=hORvZr95wHSu1yC1JneQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello all,

I have a question regarding the memory usage I'm seeing in one of my
servers. This servers was recently installed using CentOS 7 and PostgreSQL
9.3

The server has 128GB of ram and we've configured postgresql.conf to use as
much memory as it can (it's a dedicate postgres server after all)

What we're seeing is that even at high peaks of load the server doesn't
consume more than 14GB, increasing the load doesn't increase ram usage
equally. We find this odd since we've other servers that are CentOS 6.5 and
postgres 9.3 and postgres 8.4, and all use all the ram available.

This particular server was a CentOS 6.5 and postgres 9.1 before and was
able to use all 128GB of ram, now it doesn't for some reason.

I know that shared memory usage in postgres was changed on 9.3 from sys v
to posix so changing things like shmmax and the like aren't needed anymore
(although we've trying changing those to no effect)

We've even seen out of memory errors on postgres logs a few times when the
server is just using something like 8GB out of 128GB of ram

Has anyone experienced a similar issue or have seen weird memory usage
patrons with CentOS 7?

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jeff Frost 2014-10-12 17:56:10 Re: PostgreSQL 9.3 abd CentOS 7 memory usage
Previous Message Guillaume Lelarge 2014-10-11 13:23:36 Re: Fwd: Auto-complete and Calltips in SQL Editor