Postgres Pro
Downloads
Home   >   mailing lists

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

From Andreas Joseph Krogh
Subject Move pg_largeobject to a different tablespace *without* turning on system_table_mods.
Date
Msg-id VisenaEmail.6f.dec0c6e22a09ab7c.157d7e67d1e@tc7-visena
Whole thread Raw
Responses Re: Move pg_largeobject to a different tablespace *without* turning on system_table_mods.
List pgsql-hackers
Tree view
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
Attachment

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Query cancel seems to be broken in master since Oct 17
Next
From: Heikki Linnakangas
Date:
Subject: Re: Query cancel seems to be broken in master since Oct 17