Postgresql went crazy and flooded all the SSD

From: Gabriel Dodan <gabriel(dot)dodan(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Postgresql went crazy and flooded all the SSD
Date: 2023-11-06 11:11:31
Message-ID: CALZRZKAsyanV_S4dbuCBhTjMSxE8Dxmg-y=Wiw1De2WrrK_6LQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Not sure exactly what happened but Postgresql flooded all the available SSD
space and obviously crashed. It has written a lot of data in the pg_wal
folder. Most likely it was caused by replication. The postgresql instance
that crashed was a subscriber and publisher at the same time. Even so, it
was not a heavy write replication, I mean the data that needed to be
replicated was rarely updated. Has anyone else encountered such an issue?

Best!

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andreas Kretschmer 2023-11-06 11:29:20 Re: Postgresql went crazy and flooded all the SSD
Previous Message Tom Lane 2023-11-04 22:46:13 Re: Postgres limitation in user management