Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1w9lQa-001izx-2b for pgsql-performance@arkaria.postgresql.org; Mon, 06 Apr 2026 14:59:49 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w9lQZ-009cse-0d for pgsql-performance@arkaria.postgresql.org; Mon, 06 Apr 2026 14:59:47 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1w9lQY-009csV-2Z for pgsql-performance@lists.postgresql.org; Mon, 06 Apr 2026 14:59:47 +0000 Received: from smtp.outgoing.loopia.se ([93.188.3.37]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1w9lQW-00000000uqb-2fsf for pgsql-performance@postgresql.org; Mon, 06 Apr 2026 14:59:46 +0000 Received: from s807.loopia.se (localhost [127.0.0.1]) by s807.loopia.se (Postfix) with ESMTP id 6022259874C for ; Mon, 06 Apr 2026 16:59:44 +0200 (CEST) Received: from s899.loopia.se (unknown [172.22.191.5]) by s807.loopia.se (Postfix) with ESMTP id 4CEDE599E06; Mon, 06 Apr 2026 16:59:44 +0200 (CEST) Received: from localhost (unknown [172.22.191.5]) by s899.loopia.se (Postfix) with ESMTP id 4B4822C8BA7C; Mon, 06 Apr 2026 16:59:44 +0200 (CEST) X-Virus-Scanned: amavis at amavis.loopia.se X-Spam-Flag: NO X-Spam-Score: -1.2 X-Spam-Level: X-Spam-Status: No, score=-1.2 tagged_above=-999 required=6.2 tests=[ALL_TRUSTED=-1, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1] autolearn=disabled Authentication-Results: s473.loopia.se (amavis); dkim=pass (2048-bit key) header.d=proxel.se Received: from s934.loopia.se ([172.22.191.5]) by localhost (s473.loopia.se [172.22.190.13]) (amavis, port 10024) with LMTP id dsAiSp2fE5Nk; Mon, 6 Apr 2026 16:59:43 +0200 (CEST) X-Loopia-Auth: user X-Loopia-User: andreas@proxel.se X-Loopia-Originating-IP: 147.28.75.140 Received: from [192.168.0.121] (customer-147-28-75-140.stosn.net [147.28.75.140]) (Authenticated sender: andreas@proxel.se) by s934.loopia.se (Postfix) with ESMTPSA id 679217CE94E; Mon, 06 Apr 2026 16:59:43 +0200 (CEST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=proxel.se; s=loopiadkim1707418970; t=1775487583; bh=SEaaFFLJRwXyvNWzIHmz/IhaRxgc0HNQG2roFvpuNw8=; h=Date:Subject:To:References:From:In-Reply-To; b=L/9vhCETDJdDoUCcrjm0nX1cUJhXETRk04NwLY2+gPfxhAMh6HcFatflKydxH50OZ okt/Fly12JjUJnKtYZ/3YrwBpSM0vvthhI9iVGB48MvnpKx1lErJ/xPaaVnG1e/sOS dcmXQolU3oMhmaYsHrAfIn1lR5q2qifo/itnL7Wnh4wCmpcQhR1wP1AgnKeN9f0OzV +MfvX3dsT5TAVeF9ClhvKJXDFgUSos1ccDHOtTVGg+8Tteyy61U46/rAe9c1jh0sM/ 9kWb0T6SSkgYolZrJB/Ctha8P7ANSm2l7njMLWlwp/sY6zMOBOAFmp65CpW2fNCHRX nFH5Z5NBuhFRQ== Message-ID: Date: Mon, 6 Apr 2026 16:59:42 +0200 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Linux 7.0 performance degradation To: Rick Otten , "pgsql-performa." References: From: Andreas Karlsson Content-Language: en-US In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 4/6/26 4:12 PM, Rick Otten wrote: > I read this article of the weekend which was reporting that the latest > Linux kernel kills postgresql performance: > https://www.phoronix.com/news/Linux-7.0-AWS-PostgreSQL-Drop www.phoronix.com/news/Linux-7.0-AWS-PostgreSQL-Drop> > > I haven't seen any discussion here about this yet and was wondering what > your thoughts are?  Are we doing to have to upgrade our postgresql > versions before we can upgrade our Linux kernel?  Are there any hacks or > tricks or workarounds to help mitigate this issue? > > Is it real? I recommend reading the linked thread[1] at LKML where Andres determined that the regression is likely only present when you do not use huge pages. So as long as you make sure that you use huge pages, which you should anyway, there is no need to worry about this regression. You can also read some discussion at Hacker News where Andres () is also involved in the discussion[2]. 1. https://lore.kernel.org/lkml/xxbnmxqhx4ntc4ztztllbhnral2adogseot2bzu4g5eutxtgza@dzchaqremz32/ 2. https://news.ycombinator.com/item?id=47644864 Andreas