Re: pg_wal folder high disk usage

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Paul Brindusa <paulbrindusa88(at)gmail(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: pg_wal folder high disk usage
Date: 2024-10-31 13:11:04
Message-ID: 607f4ee059f7d7520f420ddd30fdf2405355f5b0.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, 2024-10-31 at 10:36 +0000, Paul Brindusa wrote:
> On one of our postgres instances we have the pg_wal/data folder up to 196GB, out of 200GB disk filled up.
> This has stopped the posgresql.service this morning causing two applications to crash.
> Unfortunately our database admin is on leave today, and we are trying to figure out how to get the disk down?
> Any ideas or suggestions are more than welcome.

Check why pg_wal is growing:
https://www.cybertec-postgresql.com/en/why-does-my-pg_wal-keep-growing/

Yours,
Laurenz Albe

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Don Seiler 2024-10-31 16:01:55 Re: Index Partition Size Double of its Table Partition?
Previous Message Laurenz Albe 2024-10-31 13:08:00 Re: COPY documentation with regard to references constraints