public inbox for [email protected]  

help / color / mirror / Atom feed

From: Adrian Klaver <[email protected]>
To: Marcin Gozdalik <[email protected]>
Cc: [email protected]
Subject: Re: Changing locale of an existing database
Date: Tue, 17 Jun 2025 14:01:02 -0700
Message-ID: <[email protected]> (raw)
In-Reply-To: <CADu1mROP5-zURekH1gF69W3Hz3pteryM=8T4-VJWM3shKM9mKQ@mail.gmail.com>
References: <CADu1mRP=rTC2WX=-EWqCX-CWjp9q09xxuEkK=2Se3wx1HasSkQ@mail.gmail.com>
	<[email protected]>
	<CADu1mROP5-zURekH1gF69W3Hz3pteryM=8T4-VJWM3shKM9mKQ@mail.gmail.com>

On 6/17/25 10:30, Marcin Gozdalik wrote:
> Around 100 DBs, ranging from 1TB to 50TB.
> Initial testing showed that it takes 1.5h to dump the DB and 3h to 
> restore it for a DB of around 3TB.
> 
> Just recreating the indexes takes around 30 minutes on the same DBs.
> 
> I understand that pg_dump/pg_restore is the safe route but it's too slow 
> for me so I'd like to understand if I have any alternative.

Alright I see the issue. I don't know enough about this to say whether 
directly altering the system catalog would be a safe operation or not. 
An answer to that is going to need to come from someone with more 
knowledge on Postgres internals then I.



-- 
Adrian Klaver
[email protected]

view thread (4+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Changing locale of an existing database
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox