From: Laurenz Albe <laurenz.albe@cybertec.at>
To: mhararci@gmail.com
To: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #19051: Is it possible to move a TOAST table to a different tablespace than its parent table?
Date: Sun, 14 Sep 2025 12:29:09 +0200
Message-ID: <a55b608844e040ffaa89df481c0ed9e76603b1e8.camel@cybertec.at> (raw)
In-Reply-To: <19051-90b4476ef19f9b73@postgresql.org>
References: <19051-90b4476ef19f9b73@postgresql.org>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: laurenz.albe@cybertec.at, mhararci@gmail.com, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #19051: Is it possible to move a TOAST table to a different tablespace than its parent table?
In-Reply-To: <a55b608844e040ffaa89df481c0ed9e76603b1e8.camel@cybertec.at>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox