Re: [GENERAL] Calculating memory allocaiton per process

2011-04-14 Thread David Kerr
On Thu, Apr 14, 2011 at 03:00:07PM -0400, Jerry Sievers wrote: - David Kerr 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_

Re: [GENERAL] Calculating memory allocaiton per process

2011-04-14 Thread Jerry Sievers
David Kerr 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 =)

[GENERAL] Calculating memory allocaiton per process

2011-04-14 Thread David Kerr
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 =) Something similar to Table 17-2