=?UTF-8?Q?Ulf_Lohbr=C3=BCgge?= writes:
> A database cluster (PostgreSQL 12.4 running on Amazon Aurora @
> db.r5.xlarge) with a single database of mine consists of 1,656,618 rows in
> pg_class.
Ouch.
> Using pg_dump on that database leads to excessive memory usage
> and sometimes even a kill by s
On 9/19/2021 8:05 AM, Ranier Vilela wrote:
Em dom., 19 de set. de 2021 às 07:05, Ulf Lohbrügge
mailto:ulf.lohbrue...@gmail.com>> escreveu:
Hi there,
A database cluster (PostgreSQL 12.4 running on Amazon Aurora @
db.r5.xlarge) with a single database of mine consists of 1,656,618
On Sun, Sep 19, 2021 at 2:06 PM Ranier Vilela wrote:
> Can you try:
>
> 1. Limit resource usage by Postgres, with cgroups configuration.
>
Since the database cluster is running at AWS, I have no access to any
cgroups configuration.
> 2. pg_dump compression: man pgsql -Z
>
I don't see how this w
Hi Tom,
I was out of this list for a while.
Unfortunately, I have now no access to the server where I have seen this.
Best regards
Michel SALAIS
-Message d'origine-
De : Tom Lane
Envoyé : vendredi 10 septembre 2021 19:42
À : Michel SALAIS
Cc : 'Julien Rouhaud' ; 'postgres performance
Em dom., 19 de set. de 2021 às 07:05, Ulf Lohbrügge <
ulf.lohbrue...@gmail.com> escreveu:
> Hi there,
>
> A database cluster (PostgreSQL 12.4 running on Amazon Aurora @
> db.r5.xlarge) with a single database of mine consists of 1,656,618 rows in
> pg_class. Using pg_dump on that database leads to
Hi there,
A database cluster (PostgreSQL 12.4 running on Amazon Aurora @
db.r5.xlarge) with a single database of mine consists of 1,656,618 rows in
pg_class. Using pg_dump on that database leads to excessive memory usage
and sometimes even a kill by signal 9:
2021-09-18 16:51:24 UTC::@:[29787]:LO
