Skip site navigation (1) Skip section navigation (2)

Re: Memory question

From: Jord Tanner <jord(at)indygecko(dot)com>
To: Patrick Hatcher <PHatcher(at)macys(dot)com>,pgsql-performance(at)postgresql(dot)org
Subject: Re: Memory question
Date: 2003-06-27 20:17:04
Message-ID: 1056745023.4726.50.camel@gecko (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
On Fri, 2003-06-27 at 12:09, Patrick Hatcher wrote:

> I have 6gig Ram box.  I've set my shmmax  to 3072000000.  The database
> starts up fine without any issues.  As soon as a query is ran
> or a FTP process to the server  is done, the used memory shoots up and
> appears to never be released.

In my experience Linux likes to allocate almost all available RAM. I've
never had any trouble with that. I'm looking at the memory meter on my
RH9 development workstation and it is at 95%. Performance is good, so I
just trust that the kernel knows what it is doing.

> Mem:  6711564K av, 6517776K used,  193788K free,       0K shrd,   25168K
> buff
> Swap: 2044056K av,       0K used, 2044056K free                 6257620K
> cached

I've heard anecdotally that Linux has troubles if the swap space is less
than the RAM size. I note that you have 6G of RAM, but only 2G of swap. 

I'm sure others on the list will have more definitive opinions.

Jord Tanner <jord(at)indygecko(dot)com>

In response to


pgsql-performance by date

Next:From: Matthew HixsonDate: 2003-06-27 20:30:28
Subject: Re: Memory question
Previous:From: Patrick HatcherDate: 2003-06-27 19:59:23
Subject: Re: Memory question

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group