X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 83382D1B169 for ; Fri, 11 Jun 2004 11:54:30 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 52888-10 for ; Fri, 11 Jun 2004 14:54:28 +0000 (GMT) Received: from xtecnica.com (host154-218.pool80206.interbusiness.it [80.206.218.154]) by svr1.postgresql.org (Postfix) with ESMTP id 2BFE2D1B18F for ; Fri, 11 Jun 2004 11:54:23 -0300 (ADT) Received: from DOMENICO2K by xtecnica.com (MDaemon.PRO.v7.1.0.R) with ESMTP id md50000021096.msg for ; Fri, 11 Jun 2004 16:52:34 +0200 Message-ID: <004c01c44fc3$d7cdeaf0$70c8007e@xtecnica.it> Reply-To: "Domenico Sgarbossa" From: "Domenico Sgarbossa" To: "Rosser Schwarz" , References: <003c01c44fbd$c84a6af0$2500fa0a@CardServices.TCI.com> Subject: Re: [BULK] Problems with vacuum! Date: Fri, 11 Jun 2004 16:53:22 +0200 Organization: XTECNICA srl MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 1 X-MSMail-Priority: High X-Mailer: Microsoft Outlook Express 5.50.4927.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4927.1200 X-Authenticated-Sender: domenico@xtecnica.com X-Spam-Processed: xtecnica.com, Fri, 11 Jun 2004 16:52:34 +0200 (not processed: message from valid local sender) X-MDRemoteIP: 126.0.200.112 X-Return-Path: domenico@xtecnica.com X-MDaemon-Deliver-To: pgsql-performance@postgresql.org X-MDAV-Processed: xtecnica.com, Fri, 11 Jun 2004 16:52:35 +0200 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.0 tagged_above=0.0 required=5.0 tests=X_MSMAIL_PRIORITY_HIGH, X_PRIORITY_HIGH X-Spam-Level: * X-Archive-Number: 200406/127 X-Sequence-Number: 7185 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" To: "'Domenico Sgarbossa'" ; 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. > > >