Re: min_wal_size > max_wal_size is accepted

Hi,

Le jeu. 7 mai 2020 à 11:13, Marc Rechté <marc4(at)rechte(dot)fr> a écrit :

> Hello,
>
> It is possible to startup an instance with min > max, without the system
> complaining:
>
> mrechte=# show min_wal_size ;
>
> 2020-05-07 11:12:11.422 CEST [11098] LOG: durée : 0.279 ms
>
> min_wal_size
>
> --------------
>
> 128MB
>
> (1 ligne)
>
>
>
> mrechte=# show max_wal_size ;
>
> 2020-05-07 11:12:12.814 CEST [11098] LOG: durée : 0.275 ms
>
> max_wal_size
>
> --------------
>
> 64MB
>
> (1 ligne)
>
>
> This could be an issue ?
>
>
I don't see how this could be an issue. You'll get a checkpoint every time
64MB have been written before checkpoint_timeout kicked in. And WAL files
will be removed if you have more than 128MB of them.

Not the smartest configuration, but not a damaging one either.

--
Guillaume.