From: Guillaume Nobiron <guillaume.nobiron@vif.tm.fr>
To: pgsql-performance@postgresql.org
Subject: Swapping and Kernel 2.6
Date: Tue, 10 May 2005 15:01:13 +0200
Message-ID: <001001c55560$58765aa0$72010180@Guillaumen> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: guillaume.nobiron@vif.tm.fr
Subject: Re: Swapping and Kernel 2.6
In-Reply-To: <001001c55560$58765aa0$72010180@Guillaumen>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox