Thanks John! This is very helpful...
Just one detail I'd like to double check:
>It's easy, on Linux don't even have to reboot. Other OS's are harder.
> See this very helpful page:
>In fact, I tend to up my SHMMAX and SHMMALL and shared_buffers [...]
According to that document, I should put the same value for the
SHMMAX and SHMMALL -- however, when I do:
on my Linux system (RedHat 7.3, soon to upgrade to 8.0), I
get different values, shmmall being shmmax divided by 16
Is that normal? What should I do? Should I follow the exact
same instructions from that document and set both to the
exact same value?
Are the default values set that way (i.e., different values)
for some strange reason, or is it that on the 2.4 kernel
the shmmall is indicated in blocks of 16 bytes or something
In response to
pgsql-performance by date
|Next:||From: James Kelty||Date: 2002-10-29 00:00:38|
|Subject: Re: Clusters|
|Previous:||From: eric soroos||Date: 2002-10-28 21:56:14|
|Subject: Low Budget Performance|