X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 4DA85D1B537 for ; Thu, 30 Oct 2003 19:52:12 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 19687-10 for ; Thu, 30 Oct 2003 15:51:42 -0400 (AST) Received: from spirit.aldeiadigital.com.br (iplus-fac-225-213-137.xdsl-fixo.ctbcnetsuper.com.br [200.225.213.137]) by svr1.postgresql.org (Postfix) with ESMTP id 28881D1B53A for ; Thu, 30 Oct 2003 15:51:35 -0400 (AST) Received: from webmail.ad2.com.br (localhost.localdomain [127.0.0.1]) by spirit.aldeiadigital.com.br (8.11.6/8.11.6) with SMTP id h9UJn8E17218 for ; Thu, 30 Oct 2003 17:49:08 -0200 Received: from 192.168.1.120 (SquirrelMail authenticated user alepaes) by webmail.ad2.com.br with HTTP; Thu, 30 Oct 2003 17:49:08 -0200 (BRST) Message-ID: <1311.192.168.1.120.1067543348.squirrel@webmail.ad2.com.br> Date: Thu, 30 Oct 2003 17:49:08 -0200 (BRST) Subject: Pg+Linux swap use From: "alexandre :: aldeia digital" To: pgsql-performance@postgresql.org User-Agent: SquirrelMail/1.4.0 MIME-Version: 1.0 Content-Type: text/plain;charset=iso-8859-1 X-Priority: 3 Importance: Normal X-Virus-Scanned: by amavisd-milter (http://amavis.org/) X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/773 X-Sequence-Number: 4521 Hi, Old: Post 7.3.2, P4 1.8, 1 MB RAM, 2 x IDE SW RAID 1, RedHat 8 New: Post 7.3.4, Xeon 2.4, 1 MB RAM, 2 x SCSI 15k SW RAID 1, RedHat 9 Both use: Only postgresql on server. Buffers = 8192, effective cache = 100000 In old plataform the free and vmstat reports no use of swap. In new, the swap is in constant use (40-100 MB), with a low but constant swap out and swap in. The cache memory ~ 830000 and buffers ~ 43000 I try to reduce the buffers to 1024 with no effects. Thanks, Alexandre