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.
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?
In response to
pgsql-general by date
|Next:||From: Carl von Clausewitz||Date: 2011-04-14 20:17:54|
|Subject: Re: Vacuumdb error|
|Previous:||From: Greg Smith||Date: 2011-04-14 19:14:11|
|Subject: Re: SSDs with Postgresql?|