Re: Sv: WAL-dir filling up with wal_level = logical

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: Andreas Kretschmer <andreas(at)a-kretschmer(dot)de>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org, Andreas Joseph Krogh <andreas(at)visena(dot)com>
Subject: Re: Sv: WAL-dir filling up with wal_level = logical
Date: 2018-08-03 21:04:27
Message-ID: 20180803210427.GE20967@paquier.xyz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)visena(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ertan Küçükoğlu 2018-08-03 21:33:12 RE: Eror while dropping a user
Previous Message Alessandro Aste 2018-08-03 21:02:22 Re: Eror while dropping a user