Re: Sv: WAL-dir filling up with wal_level = logical - Mailing list pgsql-general

From Michael Paquier
Subject Re: Sv: WAL-dir filling up with wal_level = logical
Date
Msg-id 20180803210427.GE20967@paquier.xyz
Whole thread Raw
In response to Re: Sv: WAL-dir filling up with wal_level = logical  (Andreas Kretschmer <andreas@a-kretschmer.de>)
List pgsql-general
On Fri, Aug 03, 2018 at 12:40:16PM +0200, Andreas Kretschmer wrote:
> On 3 August 2018 12:33:26 CEST, Andreas Joseph Krogh <andreas@visena.com> wrote:
>>Hm, a co-worker noticed that we have max_wal_size = 16GB, that might be
>>the
>>reason:-)
>
> Yes ;-)

Worth mentioning that this is a soft size, and not a hard size, hence
depending on your worload you may see more WAL segments than what is set
in 16GB.  The docs mention that, so no need to be surprised.
--
Michael

Attachment

pgsql-general by date:

Previous
From: Alessandro Aste
Date:
Subject: Re: Eror while dropping a user
Next
From: Ertan Küçükoğlu
Date:
Subject: RE: Eror while dropping a user