Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
From: Alex Balashov <abalashov@evaristesys.com>
Mime-Version: 1.0 (1.0)
Subject: Re: pg_wal keeps growing
Date: Wed, 3 Feb 2021 11:00:17 -0500
Message-Id: <BCAE1B1C-D694-4CE3-9EEF-ED610BD3F9B1@evaristesys.com>
References: 
 <CALhHtcCBE2mSLp3XWr659ga-KE8_YDh9YGD9jJ0NBD8TBy1RpA@mail.gmail.com>
In-Reply-To: 
 <CALhHtcCBE2mSLp3XWr659ga-KE8_YDh9YGD9jJ0NBD8TBy1RpA@mail.gmail.com>
To: pgsql-admin@lists.postgresql.org
Sender: sasha@isando.evaristesys.co.za
Precedence: bulk

Are you sure you don=E2=80=99t have a replication slot with no replication c=
onsumer connected to it?

Replication slots cause WALs to accumulate until someone connects to the slo=
t and downloads them.

=E2=80=94
Sent from my iPad

> On Feb 3, 2021, at 10:53 AM, Yambu <hyambu@gmail.com> wrote:
>=20
> =EF=BB=BF
> Hello
>=20
> My pg_wal directory keeps growing in size. Im using Pg v10
>=20
> Currently its at 53GB in size.
>=20
> Below are my settings
>=20
>  select name,setting,unit from pg_settings where name ilike '%wal%';
>              name             |  setting  | unit
> ------------------------------+-----------+------
>  max_wal_senders              | 10        |
>  max_wal_size                 | 1024      | MB
>  min_wal_size                 | 80        | MB
>  wal_block_size               | 8192      |
>  wal_buffers                  | 2048      | 8kB
>  wal_compression              | off       |
>  wal_consistency_checking     |           |
>  wal_keep_segments            | 0         |
>  wal_level                    | replica   |
>  wal_log_hints                | off       |
>  wal_receiver_status_interval | 10        | s
>  wal_receiver_timeout         | 60000     | ms
>  wal_retrieve_retry_interval  | 5000      | ms
>  wal_segment_size             | 2048      | 8kB
>  wal_sender_timeout           | 60000     | ms
>  wal_sync_method              | fdatasync |
>  wal_writer_delay             | 200       | ms
>  wal_writer_flush_after       | 128       | 8kB
> (18 rows)