There's lots that can be done to improve the machines caching. Check out cacheman 5.11. How do you know its not using all the ram? A rushmore bitmap for 10 million records should only require approximately 1.2Mb of RAM.

>I have been given a new machine that has a little over 1 GB of RAM. When running queries on large tables (8 to 10 mil records) with joins, it does not appear to be utilizing all of the RAM.
>
>Any suggestions?