RE: Can we have multiple tablespaces with in a database.

Thanks Patrick , From: Patrick FICHE Sent: Friday, February 21, 2020 9:54 PM To: Daulat Ram ; amul sul Cc: pgsql-performance@lists.postgresql.org Subject: RE: Can we have multiple tablespaces with in a database. Hi, You can create more than one tablespace and assign different objects on diffe

RE: Can we have multiple tablespaces with in a database.

Hi, You can create more than one tablespace and assign different objects on different tablespaces. For example : CREATE TABLESPACE test_data OWNER test LOCATION '/tmp/test_data'; CREATE TABLESPACE test_idx OWNER test LOCATION '/tmp/test_idx'; CREATE DATABASE test WITH TABLESPACE = test_data; Th