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