Re: Postgresql Memory Problem

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: dotaku <dotaku(at)hotpop(dot)com>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Postgresql Memory Problem
Date: 2003-10-20 17:23:44
Message-ID: Pine.LNX.4.33.0310201122100.8441-100000@css120.ihs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Mon, 20 Oct 2003, dotaku wrote:

> Hi all..
>
> i've got a problem with the memory that postgresql 7.3.2 used in RedHat 9.
> When the memory usage reached 80% or more of the total memory in the
> system..
> the memory just keep stuck there..The thing did not reduce bt itself...
>
> Then i decided to stop the postgresql service. But ...the memory that
> postgresql used still stuck...I used top to check the memory...
>
> The only way to solved it now...is via rebooting the machine..But that
> is ridiculous..
> Need Help....maybe i miss configured the postgresql.conf.
>
> But give me something to tinker with..

Are you talking about something like this:

Mem: 1543980K av, 1538248K used, 5732K free, 266768K shrd, 36064K buff
Swap: 2048208K av, 194532K used, 1853676K free 802612K cached

Where I'm only showing 5732k free, but 802612k cached? That's normal.
The linux kernel is just using the spare memory for file caching until
something tries to allocate a big chunk of memory, then it will give it
back. That's normal operation.

Or is it something else?

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message David F. Skoll 2003-10-20 17:30:23 Re: sql scripts
Previous Message Josh Berkus 2003-10-20 17:07:48 Re: [PERFORM] Low Insert/Update Performance