ram drive
От | Timothy D McKernan |
---|---|
Тема | ram drive |
Дата | |
Msg-id | 3DDE769F.6030804@dyrectmedia.com обсуждение исходный текст |
Ответ на | Database backup and restore ("Colin Stearman" <cstearman@infofind.com>) |
Список | pgsql-admin |
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
В списке pgsql-admin по дате отправления: