MIME-Version: 1.0
From: Rama Krishnan <raghuldrag@gmail.com>
Date: Tue, 17 Dec 2024 19:11:55 +0530
Message-ID: <CAJWX+EMoXWiSu3Jev9p71VmZ+jGBKuYg3J2r5ZDxsuuKpPbHcw@mail.gmail.com>
Subject: Query about pg_wal directory filled up
To: Postgres General <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000086c254062977767b"
Archived-At: <https://www.postgresql.org/message-id/CAJWX%2BEMoXWiSu3Jev9p71VmZ%2BjGBKuYg3J2r5ZDxsuuKpPbHcw%40mail.gmail.com>
Precedence: bulk

--00000000000086c254062977767b
Content-Type: text/plain; charset="UTF-8"

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

--00000000000086c254062977767b
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div><br clear=3D"all"></div><div><div dir=3D"ltr" class=
=3D"gmail_signature" data-smartmail=3D"gmail_signature"><div dir=3D"ltr"><s=
pan style=3D"font-family:comic sans ms,sans-serif">Hi Team,</span><div></di=
v></div><div dir=3D"ltr"><br></div><div>One of our clients recently migrate=
d from Oracle to PostgreSQL and is conducting multiple scenarios to underst=
and PostgreSQL behavior. =C2=A0<br><br>One of their main concerns is whethe=
r the database will allow `INSERT` queries when the `pg_wal` directory beco=
mes full. =C2=A0<br><br>As I understand, once the `pg_wal` directory is com=
pletely filled, the database will allow only read queries and will not perm=
it any write operations. =C2=A0<br><br>Kindly advise<br></div><div><br></di=
v><div><br></div><div>Thanks</div><div>RK</div></div></div></div>

--00000000000086c254062977767b--