Move pg_largeobject to a different tablespace *without* turning on system_table_mods.

From: Andreas Joseph Krogh <andreas(at)visena(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Move pg_largeobject to a different tablespace *without* turning on system_table_mods.
Date: 2016-10-18 13:13:58
Message-ID: VisenaEmail.6f.dec0c6e22a09ab7c.157d7e67d1e@tc7-visena
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi -hackers.
 
From time to time pg_largeobject comes up as an issue with being implemented
as a system-catalog.
 
As I see it, there are 2 relevant use-cases for improving the situation:
1. Being able to pg_dump *without* any LOs (think of it as
   without the contents of pg_largeobject). This is very handy
   for testing/troubleshooting.
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.

Anyone willing to discuss this?
 
Thanks.
 
-- Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andreas(at)visena(dot)com <mailto:andreas(at)visena(dot)com>
www.visena.com <https://www.visena.com>
<https://www.visena.com>

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Heikki Linnakangas 2016-10-18 13:31:00 Re: Query cancel seems to be broken in master since Oct 17
Previous Message Tom Lane 2016-10-18 13:13:46 Re: Query cancel seems to be broken in master since Oct 17