| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | mhararci(at)gmail(dot)com, pgsql-bugs(at)lists(dot)postgresql(dot)org |
| Subject: | Re: BUG #19051: Is it possible to move a TOAST table to a different tablespace than its parent table? |
| Date: | 2025-09-14 10:29:09 |
| Message-ID: | a55b608844e040ffaa89df481c0ed9e76603b1e8.camel@cybertec.at |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Laurenz Albe | 2025-09-14 10:43:20 | Re: Version 17.6 changed how similar works compared to version 17.5 |
| Previous Message | PG Bug reporting form | 2025-09-14 09:17:05 | BUG #19051: Is it possible to move a TOAST table to a different tablespace than its parent table? |