Is it possible to allocate tables directly to tablespaces within a single database/schema in postgres? Based on the docs, tablespace is a create database
argument, but are there any workarounds?
PostgreSQL Multiple Tablespaces in Single Database – How to Use
database-designpostgresqltablespaces
Related Question
- DB2 LUW: Should temporary tablespaces share bufferpools with other tablespaces
- Oracle – Performance Benefits of Segregating Database Objects into Different Tablespaces
- PostgreSQL – Replicating Multidisk Master to Single Disk Slave
- Oracle – How to Alter Multiple Tablespaces at Once
- Oracle Permissions – Schema Grants and Tablespaces
- Postgresql – How to list all items from all databases located in a specific tablespace in postgresql
Best Answer
Yes it's possible.
As documented in the manual you can specify a tablespace when creating a table.
However, tablespaces are rarely used in Postgres as they don't really provide any advantage.
One of the few reasons to use them is, when you can't easily expand the size of your filesystem where the data directory is located.