Re: [PERFORM] how big shmmax is good for Postgres...

2008-07-10 Thread Scott Marlowe
Some corrections: On Thu, Jul 10, 2008 at 6:11 AM, Scott Marlowe <[EMAIL PROTECTED]> wrote: SNIP > If you commonly have 100 transactions doing that at once, then you > multiply much memory they use times 100 to get total buffer >> SPACE << in > use, > and the rest is likely NEVER going to get u

Re: [PERFORM] how big shmmax is good for Postgres...

2008-07-10 Thread Scott Marlowe
I just wanted to add to my previous post that shared_memory generally has a performance envelope of quickly increasing performance as you first increase share_memory, then a smaller performance step with each increase in shared_memory. Once all of the working set of your data fits, the return star

Re: [PERFORM] how big shmmax is good for Postgres...

2008-07-10 Thread Scott Marlowe
On Thu, Jul 10, 2008 at 4:53 AM, Jessica Richard <[EMAIL PROTECTED]> wrote: > On a Linux system, if the total memory is 4G and the shmmax is set to 4G, I > know it is bad, but how bad can it be? Just trying to understand the impact > the "shmmax" parameter can have on Postgres and the entire sys

Re: [PERFORM] how big shmmax is good for Postgres...

2008-07-10 Thread Bill Moran
In response to Jessica Richard <[EMAIL PROTECTED]>: > On a Linux system, if the total memory is 4G and the shmmax is set to 4G, I > know it is bad, but how bad can it be? Just trying to understand the impact > the "shmmax" parameter can have on Postgres and the entire system after > Postgres