Re: Postgre Eating Up Too Much RAM - Mailing list pgsql-admin

From Christian Kratzer
Subject Re: Postgre Eating Up Too Much RAM
Date
Msg-id alpine.BSF.2.00.1211171649340.90763@pohjola.cksoft.de
Whole thread Raw
In response to Postgre Eating Up Too Much RAM  (Aaron Bono <aaron.bono@aranya.com>)
List pgsql-admin
Hi,

On Tue, 13 Nov 2012, Aaron Bono wrote:

> I have been struggling with an issue on our database server lately with
> Postgres crashing our server by taking up too much RAM.  To alleviate this
> problem, I just upgraded from a 6 GB RAM server to a new 32 GB RAM server.
> The new server is running Ubuntu 10 with nothing but PostgreSQL 8.4.14
> installed.
>
> Today, after being in use for only 24 hours, it hung the server again.
> Now, when I run a check on memory usage, I get a quickly growing amount of
> RAM being used:
>
> free -mt
>
>             total       used       free     shared    buffers     cached
> Mem:         30503      20626       9876          0        143      15897
> -/+ buffers/cache:       4586      25917
> Swap:         1913          0       1913
> Total:       32417      20626      11790

just in case nobody has noticed yet:

Above free output is linux telling you that use processes are using 4586 KB of ram wheres 25917 KB is free.

PostgreSQL is not hogging up you RAM.  Linux is using unused ram for buffers and cache.

This is an ancient linux FAQ.  Whatever amount of ram you put into a linux box free will show it used shortly after.
Checkthe -/+ buffers line for the values you are looking for. 

Greetings
Christian

--
Christian Kratzer                      CK Software GmbH
Email:   ck@cksoft.de                  Wildberger Weg 24/2
Phone:   +49 7032 893 997 - 0          D-71126 Gaeufelden
Fax:     +49 7032 893 997 - 9          HRB 245288, Amtsgericht Stuttgart
Web:     http://www.cksoft.de/         Geschaeftsfuehrer: Christian Kratzer


pgsql-admin by date:

Previous
From: Aaron Bono
Date:
Subject: Fwd: Postgre Eating Up Too Much RAM
Next
From: Scott Marlowe
Date:
Subject: Re: Postgre Eating Up Too Much RAM