Re: [PERFORM] Swapping and Kernel 2.6

2005-05-15 Thread Grega Bremec
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Guillaume Nobiron wrote: | 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

[PERFORM] Swapping and Kernel 2.6

2005-05-15 Thread Guillaume Nobiron
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 an