Re: Bump default wal_level to logical

Поиск
Список
Период
Сортировка
От Peter Geoghegan
Тема Re: Bump default wal_level to logical
Дата
Msg-id CAH2-WznVBnRkAa5L-KCEx-p8GUcTHkMh1azFED7s7Rk7v2VUag@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Bump default wal_level to logical  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Список pgsql-hackers
On Mon, Jun 8, 2020 at 12:28 PM Alvaro Herrera <alvherre@2ndquadrant.com> wrote:
> On a quantum-mechanics level, sure, but after Andres's snapshot
> scalability patches, will it be measurable?  (Besides, if your workload
> is so high that you're measurably affected by the additional unused
> PGPROC entries, you can always tune it lower.)

The point that Robert went on to make about the increased WAL volume
from logging old primary key (or replica identity) values was a
stronger argument, IMV.

-- 
Peter Geoghegan



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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: hashagg slowdown due to spill changes
Следующее
От: Jeff Davis
Дата:
Сообщение: Re: hashagg slowdown due to spill changes