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
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
On 6/17/25 09:20, Marcin Gozdalik wrote:
Hi
I am using PostgreSQL 17 and would like to take advantage of performance
and stability across OS updates of builtin C.UTF-8 locale.
I have a cluster with a DB created with en_US.UTF-8 libc locale. I would
like to migrate the DB to C.UTF-8. Ideally th
Hi
I am using PostgreSQL 17 and would like to take advantage of performance
and stability across OS updates of builtin C.UTF-8 locale.
I have a cluster with a DB created with en_US.UTF-8 libc locale. I would
like to migrate the DB to C.UTF-8. Ideally there'd be an "ALTER DATABASE
... SET LOCALE ..
