toast tables and toast indexes

On Tue, Dec 28, 2021 at 01:10:53PM +0000, Godfrin, Philippe E wrote:

While experimenting with toast tables I noticed that the toast index
lands in the same tablespace as the toast table itself. Is there a
way to make the toast indexes create in a different tablespace?

No. See create_toast_table() where the toast table and its index use
the same tablespace as the relation they depend on.

Now, you could use allow_system_table_mods and an ALTER INDEX .. SET
TABLESPACE to change that for the index, but this is a developer
option and you should *not* use that for anything serious:
https://www.postgresql.org/docs/devel/runtime-config-developer.html

"Ill-advised use of this setting can cause irretrievable data loss or
seriously corrupt the database system."
--
Michael