pg.ddx.io  pgsql-docs@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Pavel Luzanov <p.luzanov@postgrespro.ru>
To: Andreas Kretschmer <andreas@a-kretschmer.de>
To: pgsql-docs@lists.postgresql.org
Subject: Re: max_wal_size
Date: Wed, 27 May 2020 13:26:13 +0300
Message-ID: <97af9ef7-d7d9-cfd0-a280-d400cf05c68a@postgrespro.ru> (raw)
In-Reply-To: <5d9bf1bd-d322-ba24-ce89-fa6029eb6615@a-kretschmer.de>
References: <7020bbeb-cde5-b203-9803-2facd964688b@postgrespro.ru>
	<5d9bf1bd-d322-ba24-ce89-fa6029eb6615@a-kretschmer.de>

Andreas,

> size between checkpoints, size of all wal's can be higher, see 
> wal_keep_segments.

Hm, I also thought, but after looking at the source 
<https://github.com/postgres/postgres/blob/REL_10_STABLE/src/backend/access/transam/xlog.c#L2224;, 
it seems like this is a restriction on all files in pg_wal.

-----
Pavel Luzanov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company

view thread (16+ messages)  latest in thread

Message-ID: <97af9ef7-d7d9-cfd0-a280-d400cf05c68a@postgrespro.ru>
Permalink:  ../97af9ef7-d7d9-cfd0-a280-d400cf05c68a@postgrespro.ru/
Also on:    postgresql.org/message-id/97af9ef7-d7d9-cfd0-a280-d400cf05c68a@postgrespro.ru

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-docs@postgresql.org
  Cc: p.luzanov@postgrespro.ru, andreas@a-kretschmer.de, pgsql-docs@lists.postgresql.org
  Subject: Re: max_wal_size
  In-Reply-To: <97af9ef7-d7d9-cfd0-a280-d400cf05c68a@postgrespro.ru>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox