AuroraPostgreSQL 17.5 tablespace

Yes, you can create tablespaces in Aurora PostgreSQL 17.5.

Aurora PostgreSQL supports tablespace functionality despite using AWS-managed distributed storage because it maintains compatibility with standard PostgreSQL. Tablespaces in Aurora PostgreSQL provide logical organization of database objects and allow you to control where specific tables and indexes are stored.

Regarding the LOCATION parameter when creating tablespaces in Aurora PostgreSQL, you don't have complete freedom to specify any arbitrary location. Aurora PostgreSQL manages the physical storage automatically through its shared storage architecture. When you create a tablespace, Aurora PostgreSQL will create it in a predetermined location within the Aurora storage system. For example, tablespaces might be created in locations like "/rdsdbdata/tablespaces/app_data/tbs_0".

You can use tablespaces in Aurora PostgreSQL for various operations such as:

• Creating databases with specific tablespaces: CREATE DATABASE DB1 TABLESPACE TBS_01;
• Assigning tables to tablespaces: CREATE TABLE TBL(COL1 NUMERIC, COL2 VARCHAR(10)) TABLESPACE TBS_01;
• Assigning indexes to tablespaces: CREATE INDEX IDX_TBL ON TBL(COL1) TABLESPACE TBS_01;
• Renaming tablespaces: ALTER TABLESPACE TBS_01 RENAME TO IDX_TBS_01;
• Changing tablespace ownership: ALTER TABLESPACE TO IDX_TBS_01 OWNER TO USER1;

You can view tablespace information using PostgreSQL system catalogs.
Sources
Oracle and PostgreSQL tablespaces and data files - Oracle to Aurora PostgreSQL Migration Playbook
Amazon Aurora now supports PostgreSQL 17.5, 16.9, 15.13, 14.18, and 13.21 - AWS