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

Re: Calculating memory allocaiton per process

From: David Kerr <dmk(at)mr-paradox(dot)net>
To: Jerry Sievers <gsievers19(at)comcast(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Calculating memory allocaiton per process
Date: 2011-04-14 19:36:57
Message-ID: 20110414193657.GA36322@mr-paradox.net (view raw or flat)
Thread:
Lists: pgsql-general
On Thu, Apr 14, 2011 at 03:00:07PM -0400, Jerry Sievers wrote:
- David Kerr <dmk(at)mr-paradox(dot)net> writes:
- 
- > Howdy, 
- >
- > Is there a doc somewhere that has a formula for how much memory PG
- > backend process will use?
- >
- > I'm looking to get something like total_mem = max_connections * (
- > work_mem + temp_buffers ) // I know it's more complicated than that,
- > which is why I'm asking =)
- 
- Depends on your query complexity, load distribution across concurrent
- sessions and session lifetime.
- 
- work_mem will, in cases of queries having multiple sort nodes, have to
- be counted multiple times on behalf of a single backend.
- 
- Some observation of the running system can be your best bet.
- 
- HTH

Yeah, that's the complication that I knew about (but am still not able to
fully 'get', let along vocalize). 

Are there no rules of thumb or upper bounds to help estimate total memory usage?

Thanks

Dave

In response to

pgsql-general by date

Next:From: Carl von ClausewitzDate: 2011-04-14 20:17:54
Subject: Re: Vacuumdb error
Previous:From: Greg SmithDate: 2011-04-14 19:14:11
Subject: Re: SSDs with Postgresql?

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