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
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