Thanks for your advice!
As I immagine the system released dinamically the shared memory .... the
problem is that
when , after vacuum, users runs my application (ERP) and the system swap on
disk so the global performance
decrease very fast until the system is so slow that I need to reboot the
server.
It seems that the cached memory isn't released by the system... so the
system begin to swap to disk!
The swap problem is very important, it makes useless run vacuum 'cause after
vacuum the system
begin to swap.... so my application runs very slow!
Could you explain me better your final advice please?
> Watching this "cached" value over normal usage of your machine to get
> a running average is how you come up with your effective_cache_size
> configuration directive.
what does this mean pratically?
thanks!
Distinti Saluti
Sgarbossa Domenico
X Tecnica S.R.L.
www.xtecnica.com
Tel: 049/9409154 - 049/5970297
Fax: 049/9400288
----- Original Message -----
From: "Rosser Schwarz" <[EMAIL PROTECTED]>
To: "'Domenico Sgarbossa'" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Friday, June 11, 2004 4:09 PM
Subject: RE: [BULK] [PERFORM] Problems with vacuum!
> while you weren't looking, Domenico Sgarbossa wrote:
>
> Compare the "cached" values in each run of top.
>
> Before: 67828K cached
>
> After: 833896K cached
>
> The kernel is caching your tables for you. That memory isn't actually
> being -used-, in the active, "a process has claimed this memory" sense.
> If a process comes along that needs more memory than free, the kernel
> will flush some of those cached pages (to swap?) to make room for
> whatever the memory requirements of the newcomer are.
>
> Watching this "cached" value over normal usage of your machine to get
> a running average is how you come up with your effective_cache_size
> configuration directive.
>
> /rls
>
> --
> Rosser Schwarz
> Total Card, Inc.
>
>
>
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
