Postgres: Put 1 database in separate HD partition?

Posted on

Question :

I have 2 HD partitions – one with SSD and another with regular hard drives.

I have multiple databases (as in logical database, not physical) with 1 data directory. I want the data for 1 of the databases to reside in the SSD partition because it’s a database that will have LOT more reads/writes than the other databases. And since the SSD partition is limited in space, I can’t store all the databases there, just that one.

Is there a way to configure this in Postgres – is it possible? Is there a tutorial online that I can read? I tried Googling but all the results talk about partitioning tables logically, not across different hard drive partitions.

Answer :

You can create a table space that uses the second partition. Then just alter the database to use that partition.

CREATE TABLESPACE fastspace LOCATION '/mnt/ssdpart';

See also, and

Good luck!

Leave a Reply

Your email address will not be published. Required fields are marked *