[ADMIN] ram drive

[Timothy D McKernan]

My client would like to test using a ram drive to hold some of our postgre files. Does anybody have any suggestions for how to go about doing this? Details are below:

http://www.3dretreat.com/reviews/rocketdrive/

This is a review that explains the benefits of a ram drive: it's a pci card that holds several sticks of SDRAM, but reports it as another filesystem to linux. So the idea is that we could put several postgre tables on this card, and we will hopefully see a huge performance increase by being able to access these files from the ram drive instead of a hard drive.

Our /usr/local/pgsql/data dir is nearly 4GB in size, but our current ramdrive only holds 2GB of ram, so we can't put the whole data dir on the ramdrive.

Which files would be ideal for loading onto the ram drive? Are there specific files that contain the table indices? This ram drive is nascent ground for us, so all ideas are welcome.

Thanks,
Tim


--
Dyrect Media Group
P.O. Box 486
6000 Goodrich Rd
Clarence Center, NY 14032-0486

OFFICE: 716-504-1141 ext 208
CELL: 716-510-2451
AIM: somecallmetim100


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html