Query about pg_wal directory filled up

From: Rama Krishnan <raghuldrag(at)gmail(dot)com>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Query about pg_wal directory filled up
Date: 2024-12-17 13:41:55
Message-ID: CAJWX+EMoXWiSu3Jev9p71VmZ+jGBKuYg3J2r5ZDxsuuKpPbHcw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Team,

One of our clients recently migrated from Oracle to PostgreSQL and is
conducting multiple scenarios to understand PostgreSQL behavior.

One of their main concerns is whether the database will allow `INSERT`
queries when the `pg_wal` directory becomes full.

As I understand, once the `pg_wal` directory is completely filled, the
database will allow only read queries and will not permit any write
operations.

Kindly advise

Thanks
RK

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Enrico Schenone 2024-12-17 16:30:16 Intermittent errors when fetching cursor rows on PostgreSQL 16
Previous Message Laurenz Albe 2024-12-17 07:30:19 Re: Disabling vacuum truncate for autovacuum