Re: Bump default wal_level to logical

Поиск
Список
Период
Сортировка
От Amit Kapila
Тема Re: Bump default wal_level to logical
Дата
Msg-id CAA4eK1KcSexCbM0zjg=r_Se2wKXzaY8Qy6=-kbb3HbFJdAASOg@mail.gmail.com
обсуждение исходный текст
Ответ на Bump default wal_level to logical  (David Fetter <david@fetter.org>)
Ответы Re: Bump default wal_level to logical  (Michael Paquier <michael@paquier.xyz>)
Список pgsql-hackers
On Mon, Jun 8, 2020 at 10:08 AM David Fetter <david@fetter.org> wrote:
>
> Hi,
>
> I'd like to propose $subject, as embodied in the attached patch. This
> makes it possible to discover and fulfill a need for logical
> replication that can arise at a time when bouncing the server has
> become impractical, i.e. when there is already high demand on it.
>

I think we should first do performance testing to see what is the
overhead of making this default.  I think pgbench read-write at
various scale factors would be a good starting point.  Also, we should
see how much additional WAL it generates as compared to current
default.

-- 
With Regards,
Amit Kapila.
EnterpriseDB: http://www.enterprisedb.com



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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: race condition when writing pg_control
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: Bump default wal_level to logical