On Fri, 2005-08-12 at 17:48, [EMAIL PROTECTED] wrote:
> Hello,
>
> I followed this advice for picking a good effective_cache_size value
> (below) from Scott Marlowe, and run into a bit of trouble:
>
> I looked at the `top' output and saw "721380k cached".
> So I calculated the effective cache siz
Hello,
I followed this advice for picking a good effective_cache_size value
(below) from Scott Marlowe, and run into a bit of trouble:
I looked at the `top' output and saw "721380k cached".
So I calculated the effective cache size using Scott's formula:
721380/8 = 90172
Then I changed my effe
On Fri, 2005-07-29 at 08:24, Kailash Vyas wrote:
> hi
>
> i am optmizing postgres database and need some help on it.
> I currently have a server with 2 Gb RAM.
>
> I have setup the /proc/sys/kernel/shmall and /proc/sys/kernel/shmmax
> to 536870912 i.e 512 Mb.
> should i change it to 2 Gb and how
