Re: Can PostgreSQL create new WAL files instead of reusing old ones?

Поиск
Список
Период
Сортировка
От David Pacheco
Тема Re: Can PostgreSQL create new WAL files instead of reusing old ones?
Дата
Msg-id CACukRjM68-khjN+LxzVAqi3FHR=Av+9HdnDqyONg4PoWdfni2g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Can PostgreSQL create new WAL files instead of reusing old ones?  (Jerry Jelinek <jerry.jelinek@joyent.com>)
Ответы Re: Can PostgreSQL create new WAL files instead of reusing old ones?
Список pgsql-general
Дерево обсуждения
On Wed, Jun 20, 2018 at 10:35 AM, Jerry Jelinek <jerry.jelinek@joyent.com> wrote:
As Dave described in his original email on this topic, we'd like to avoid recycling WAL files since that can cause performance issues when we have a read-modify-write on a file that has dropped out of the cache.

I have implemented a small change to allow WAL recycling to be disabled. It is visible at:

I'd appreciate getting any feedback on this.

Thanks,
Jerry



For reference, there's more context in this thread from several months ago:

I'll repeat the relevant summary here:

tl;dr: We've found that under many conditions, PostgreSQL's re-use of old
WAL files appears to significantly degrade query latency on ZFS.  The reason is
complicated and I have details below.  Has it been considered to make this
behavior tunable, to cause PostgreSQL to always create new WAL files
instead of re-using old ones?

Thanks,
Dave

В списке pgsql-general по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: pgp_sym_decrypt() - error 39000: wrong key or corrupt data
Следующее
От: Vik Fearing
Дата:
Сообщение: Re: using pg_basebackup for point in time recovery