I am using PostgreSQL and I want to explicitly place a database with 4 gb of data in memory. I have read a lot of forums discussing whether this is a good idea and I have decided that I want to give it a try. I am using a Vista machine. I currently have only 2 gb of ram.
I have tried a lot of ramdisks and my problem is that none (that I have found) works when I assign more memory than I have. I, of course, want to use the harddisk for swapping in this case. I know the performance penalty and I believe I will still come out better. My question is whether any of you know of such ramdisk software?