Re: patch : Allow toast tables to be moved to a different tablespace - Mailing list pgsql-hackers

From Julien Tachoires
Subject Re: patch : Allow toast tables to be moved to a different tablespace
Date
Msg-id 550AF15E.4020006@gmail.com
Whole thread Raw
In response to Re: patch : Allow toast tables to be moved to a different tablespace  (Andreas Karlsson <andreas@proxel.se>)
Responses Re: patch : Allow toast tables to be moved to a different tablespace  (Andreas Karlsson <andreas@proxel.se>)
List pgsql-hackers
On 18/03/2015 19:54, Andreas Karlsson wrote:
> On 03/17/2015 09:00 AM, Julien Tachoires wrote:
>> Here is a new version fixing this issue. I've added a new kind of TOC
>> entry for being able to handle pg_restore --no-tablespace case.
>
> Looks good but I think one minor improvement could be to set the table
> space of the toast entires to the same as the tablespace of the table to
> reduce the amount of "SET default_tablespace". What do you think?

Yes, you're right, some useless "SET default_tablespace" were added for
each ALTER TABLE SET TOAST TABLESPACE statement. It's now fixed with
this new patch. Thanks.

--
Julien

Attachment

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: No toast table for pg_shseclabel but for pg_seclabel
Next
From: Robert Haas
Date:
Subject: Re: flags argument for dsm_create