10 May
2009
10 May
'09
2:11 p.m.
Mag Gam wrote:
I have limited memory on our system 16GB of memory and our tables have more than 2 billion records. The underlying storage is extremely fast (300MB/sec read and write and rewrite), therefore I would like to depend mainly on the storage versus placing everything in memory.
If you have the option to assign complete logical volume [unpartitioned] as swap this could improve your performance; depending on what storage solution you use. But as Martin mentioned you wil already benefit from memory and disks because of the mmaps. Just don't forget that your disks also require memory too :) The following is interesting respect to manually tuning under Linux: http://www.westnet.com/~gsmith/content/linux-pdflush.htm Stefan