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. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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
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

Your Answer


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.