Re: OOM killer while pg_restore

2022-03-05 Thread Ranier Vilela
Em qui., 3 de mar. de 2022 às 15:32, Marc Rechté escreveu: > Le 03/03/2022 à 16:31, Tom Lane a écrit : > > =?UTF-8?Q?Marc_Recht=c3=a9?= writes: > >> We have a pg_restore which fails due to RAM over-consumption of the > >> corresponding PG backend, which ends-up with OOM killer. > >> The table ha

Re: OOM killer while pg_restore

2022-03-05 Thread Marc Rechté
Le 03/03/2022 à 19:43, Tom Lane a écrit : =?UTF-8?Q?Marc_Recht=c3=a9?= writes: Le 03/03/2022 à 16:31, Tom Lane a écrit : Does memory consumption hold steady if you drop the FK constraints? Actually the number of rows is 232735712. Accordingly the RAM consumption would be x12 x3 = 7.8 GiB. Thi