Re: Move pg_largeobject to a different tablespace *without* turning on system_table_mods. - Mailing list pgsql-hackers

From David G. Johnston
Subject Re: Move pg_largeobject to a different tablespace *without* turning on system_table_mods.
Date
Msg-id CAKFQuwaqhDtL56CiFiaRuSpGDi3HB0WMJvXSe-rODr3w8HzH8A@mail.gmail.com
Whole thread Raw
In response to Re: Move pg_largeobject to a different tablespace *without* turning on system_table_mods.  (Bruce Momjian <bruce@momjian.us>)
Responses Re: Move pg_largeobject to a different tablespace *without* turning on system_table_mods.  (Bruce Momjian <bruce@momjian.us>)
List pgsql-hackers
On Wed, Oct 19, 2016 at 9:29 AM, Bruce Momjian <bruce@momjian.us> wrote:
On Tue, Oct 18, 2016 at 04:51:54PM +0200, Andreas Joseph Krogh wrote:
>     > 2. Being able to move pg_largeobject to a different tablespace
>     >    *without* turning on system_table_mods. This is important for
>     >    people storing LOTS of large-objects on separate
>     >    disks (non-SSD) and hence in a different tablespace.

I think an open question is why you would not want to move the other
system tables at the same time you move pg_largeobject.


​I think the theory of having all system tables except LO on SSD storage, and having LO on a less performant device, makes sense.

David J.​
 

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Move pg_largeobject to a different tablespace *without* turning on system_table_mods.
Next
From: Tom Lane
Date:
Subject: Re: Move pg_largeobject to a different tablespace *without* turning on system_table_mods.