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 9AEE65374F for ; Tue, 10 May 2005 10:01:23 -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 37876-01 for ; Tue, 10 May 2005 13:01:18 +0000 (GMT) Received: from www.vif.tm.fr (vignoninformatic.rain.fr [194.51.37.1]) by svr1.postgresql.org (Postfix) with ESMTP id CFFA1536EA for ; Tue, 10 May 2005 10:01:11 -0300 (ADT) Received: from Guillaumen (guillaumen.vif.tm.fr [128.1.1.114]) by www.vif.tm.fr (8.12.11/8.12.10) with ESMTP id j4ACtZe9029831 for ; Tue, 10 May 2005 14:55:36 +0200 From: "Guillaume Nobiron" To: Subject: Swapping and Kernel 2.6 Date: Tue, 10 May 2005 15:01:13 +0200 Message-ID: <001001c55560$58765aa0$72010180@Guillaumen> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.2627 Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-Scanned-By: MIMEDefang 2.48 on 127.0.0.1 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200505/286 X-Sequence-Number: 12450 Hi, Environment : - Fedora Core 2 (kernel 2.6.10) - postgresql 7.4.7 I am running a huge query with several joins that needs around 900 Mbytes of Memory (System RAM is 512 Mbytes). When the system starts to swap the postgres process, CPU consumed drops to around 2% (instead of around 50% on another system with kernel 2.4). The query was still working after more than 4 hours, spending the time with 98% if IO wait. So I tried to run the postmaster with the environment variable LD_ASSUME_KERNEL=2.4.1. With this, the query last 7 minutes !!! Why swapping is so bad with the new kernel ? Thanks, Guillaume