Re: BUG #19051: Is it possible to move a TOAST table to a different tablespace than its parent table?

On Sun, 2025-09-14 at 09:17 +0000, PG Bug reporting form wrote:
> I'm currently using PostgreSQL 16.10 and I've run into a challenge regarding
> moving TOAST data for a table. My goal is to have the TOAST data for a
> column stored in a different tablespace from the parent table.
> 
> Specifically, I have a users table with a profile_data column of type JSONB,
> which can contain large objects. I want the users table itself to reside in
> the ts_medium_data tablespace, while its associated TOAST data is stored in
> a separate ts_medium_toast tablespace.

Don't write to the bugs mailing list if you need help.
I have directed replies to the -general mailing list.

You won't be able to put a table and its TOAST table into different tablespaces.

But there wouldn't be any benefit in doing that anyway, so that
is no problem.  Perhaps you could detail the *real problem* you are trying
to solve...

Yours,
Laurenz Albe