Re: Query about pg_wal directory filled up

2024-12-18 Thread Saul Perdomo
On Wed, Dec 18, 2024, 5:01 a.m. Rama Krishnan wrote: > > 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

Re: Query about pg_wal directory filled up

2024-12-18 Thread Laurenz Albe
On Tue, 2024-12-17 at 19:11 +0530, Rama Krishnan wrote: > 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 queri

Query about pg_wal directory filled up

2024-12-18 Thread Rama Krishnan
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_w