Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I need to build a database with one table stored on one disk and anther table stored on a different disk (a ramdisk).

Is it possible to do it?

As far as I know, using two separate databases, one for each disk, is not efficient.

I am considering PostgreSQL, but other options can be ok. The reason I want to use a ramdisk is to deal with non critical data that can be deleted at any time, to avoid SSD wearing.

share|improve this question
add comment

1 Answer 1

up vote 2 down vote accepted

I have not done it but, if not mistaken, it can be easily accomplished with tablespaces.

Let us know how it went.

share|improve this answer
    
Yes, it seems to be the right solution. –  Pietro May 20 '13 at 14:06
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.