Re: wal_init_zero and wal_recycle

On Wed, May 27, 2020 at 7:09 PM Simon Riggs wrote: > On Wed, 27 May 2020 at 04:27, Fujii Masao wrote: >> >> Hi, >> >> The group of wal_init_zero and wal_recycle is WAL_SETTINGS in guc.c, >> but their descriptions are located in "19.6. Replication"/"19.6.1. Sending >> Servers" section. This seems

Re: max_wal_size

On Wed, May 27, 2020, 14:12 wrote: > David, > > > For 0.5 you get 2/3rds consumption: ( n / ( 1 + 0.5 ) ) = n * 2/3 > > Exactly, for checkpoint_completion_target=0.5 the distance between > checkpoints is 2/3 of max_wal_size. > > But back to the documentation of max_wal_size. > "Maximum size to

Re: max_wal_size

David, For 0.5 you get 2/3rds consumption: ( n / ( 1 + 0.5 ) ) = n * 2/3 Exactly, for checkpoint_completion_target=0.5 the distance between checkpoints is 2/3 of max_wal_size. But back to the documentation of max_wal_size. "Maximum size to let the WAL grow to between automatic WAL

Re: max_wal_size

On Wed, May 27, 2020 at 9:17 AM wrote: > David, > > > This setting is the indirect means to ensure that the WAL directory > > doesn't get too large by forcing a checkpoint thus allowing the > > corresponding WAL to be removed. > > > This is a soft limit, ok. > But the question is a little

Re: max_wal_size

David, This setting is the indirect means to ensure that the WAL directory doesn't get too large by forcing a checkpoint thus allowing the corresponding WAL to be removed. This is a soft limit, ok. But the question is a little different. Suppose we have: version >= 11, no replication slots,

Re: max_wal_size

On Wed, May 27, 2020 at 8:18 AM PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/12/runtime-config-wal.html > Description: > > About parameter max_wal_size the documentation says that "Maximum size to >

max_wal_size

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/runtime-config-wal.html Description: About parameter max_wal_size the documentation says that "Maximum size to let the WAL grow to between automatic WAL checkpoints." Is it correct? The

Re: max_wal_size

On 27.05.2020 13:16, Andreas Kretschmer wrote: Am 27.05.20 um 12:11 schrieb Pavel Luzanov: Hello, About parameter max_wal_size the documentation says: "Maximum size to let the WAL grow to between automatic

Re: max_wal_size

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 , it seems like this is a restriction on all files

Re: max_wal_size

Am 27.05.20 um 12:11 schrieb Pavel Luzanov: Hello, About parameter max_wal_size the documentation says: "Maximum size to let the WAL grow to between automatic WAL checkpoints." Is it correct? The size

max_wal_size

Hello, About parameter max_wal_size the documentation says: "Maximum size to let the WAL grow to between automatic WAL checkpoints." Is it correct? The size between automatic WAL checkpoints or the size of

Re: Change JOIN tutorial to focus more on explicit joins

On 20.05.20 23:56, Thomas Munro wrote: On Thu, May 21, 2020 at 1:37 AM PG Doc comments form wrote: The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/tutorial-join.html Description: The tutorial about joins makes the following

Re: wal_init_zero and wal_recycle

On Wed, 27 May 2020 at 04:27, Fujii Masao wrote: > Hi, > > The group of wal_init_zero and wal_recycle is WAL_SETTINGS in guc.c, > but their descriptions are located in "19.6. Replication"/"19.6.1. Sending > Servers" section. This seems a documentation bug. They should be located > in "19.5.