Re: PG11.2 - wal_level =minimal max_wal_senders = 0
От | Luca Ferrari |
---|---|
Тема | Re: PG11.2 - wal_level =minimal max_wal_senders = 0 |
Дата | |
Msg-id | CAKoxK+6=aEQ=9j7i9vQRYU-mUn3uiLB+_AgN1tGR0skE6mN46w@mail.gmail.com обсуждение исходный текст |
Ответ на | PG11.2 - wal_level =minimal max_wal_senders = 0 (Jason Ralph <jralph@affinitysolutions.com>) |
Ответы |
RE: PG11.2 - wal_level =minimal max_wal_senders = 0
|
Список | pgsql-general |
On Wed, Sep 4, 2019 at 5:15 PM Jason Ralph <jralph@affinitysolutions.com> wrote: > The question I have is, for a production database not doing replication, can I safely set the following parameters, I understandthat minimal will also disable wal_archiving so I am concerned about that as well. > > wal_level = minimal > > max_wal_senders = 0 > > > > I have been looking at the documentation and I guess I am looking for a yes this is ok, I figured it’s on by default fora reason so I was hesitant to change it. I don't see why you should not set them as you described. The idea is that the overhead of having replica over minimal is today enough "low" in contrast to the need for replication (e.g., backup tools like pgbackrest). Luca
В списке pgsql-general по дате отправления: