Re: extremly low memory usage

From: Jeff Trout
Subject: Re: extremly low memory usage
Date: ,
Msg-id: EA4219B9-E2B0-4756-ABF2-D84F245FDFB5@torgo.978.org
(view: Whole thread, Raw)
In response to: extremly low memory usage  (Jeremiah Jahn)
Responses: Re: extremly low memory usage  (Jeremiah Jahn)
List: pgsql-performance

Tree view

extremly low memory usage  (Jeremiah Jahn, )
 Re: extremly low memory usage  (John A Meinel, )
  Re: extremly low memory usage  (Jeremiah Jahn, )
   Re: extremly low memory usage  (John Arbash Meinel, )
 Re: extremly low memory usage  (Jeff Trout, )
  Re: extremly low memory usage  (Jeremiah Jahn, )
   Re: extremly low memory usage  (John Arbash Meinel, )
    Re: extremly low memory usage  (Ron, )
    Re: extremly low memory usage  (Jeremiah Jahn, )
     Re: extremly low memory usage  (John A Meinel, )
      Re: extremly low memory usage  (Ron, )
       Re: extremly low memory usage  (John A Meinel, )
        Re: extremly low memory usage  (Jeremiah Jahn, )
         Re: extremly low memory usage  (Ron, )
          Re: extremly low memory usage  (Jeremiah Jahn, )
        Re: extremly low memory usage  (Jeremiah Jahn, )
         Re: extremly low memory usage  (John A Meinel, )
          Re: extremly low memory usage  (Jeremiah Jahn, )
           Re: extremly low memory usage  (Ron, )
           Re: extremly low memory usage  (John A Meinel, )
         Re: extremly low memory usage  (Dan Harris, )
          Re: extremly low memory usage  (Marko Ristola, )
           Re: extremly low memory usage  (Michael Stone, )
            Re: extremly low memory usage  (Tom Lane, )
             Re: extremly low memory usage  (Marko Ristola, )
          Re: extremly low memory usage  (Michael Stone, )
      Re: extremly low memory usage  (Jeremiah Jahn, )
       Re: extremly low memory usage  (John A Meinel, )
        Re: extremly low memory usage  (Jeremiah Jahn, )
         Re: extremly low memory usage  (Ron, )
          Re: extremly low memory usage  (John A Meinel, )
           Re: extremly low memory usage  (Jeremiah Jahn, )
            Re: extremly low memory usage  (John A Meinel, )
            Re: extremly low memory usage  (Ron, )
             Re: extremly low memory usage  (William Yu, )
             Re: extremly low memory usage  (Jeremiah Jahn, )
              Re: extremly low memory usage  (John A Meinel, )
 Re: extremly low memory usage  (Ron, )
 Re: extremly low memory usage  (Ron, )

On Aug 17, 2005, at 10:11 PM, Jeremiah Jahn wrote:

> I just put together a system with 6GB of ram on a 14 disk raid 10
> array.
> When I run my usual big painful queries, I get very little to know
> memory usage. My production box (raid 5 4GB ram) hovers at 3.9GB used
> most of the time. the new devel box sits at around 250MB.
>

Is the system performing fine?  Are you touching as much data as the
production box?

If the system is performing fine don't worry about it.

> work_mem = 2097151              # min 64, size in KB

This is EXTREMELY high.  You realize this is the amount of memory
that can be used per-sort and per-hash build in a query? You can end
up with multiples of this on a single query.   If you have some big
queries that are run infrequently have them set it manually.

> effective_cache_size = 3600000   <-----this is a little out of
> control, but would it have any real effect?

This doesn't allocate anything - it is a hint to the planner about
how much data it can assume is cached.

--
Jeff Trout <>
http://www.jefftrout.com/
http://www.stuarthamm.net/




pgsql-performance by date:

From: John Arbash Meinel
Date:
Subject: Re: extremly low memory usage
From: "Merlin Moncure"
Date:
Subject: Re: limit number of concurrent callers to a stored proc?