max_slot_wal_keep_size and wal_keep_segments

Поиск
Список
Период
Сортировка
Искать
От
Fujii Masao
Тема
max_slot_wal_keep_size and wal_keep_segments
Дата
Msg-id
574b4ea3-e0f9-b175-ead2-ebea7faea855@oss.nttdata.com
Список
Дерево обсуждения
max_slot_wal_keep_size and wal_keep_segments Fujii Masao <masao.fujii@oss.nttdata.com>
Re: max_slot_wal_keep_size and wal_keep_segments Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: max_slot_wal_keep_size and wal_keep_segments Alvaro Herrera <alvherre@2ndquadrant.com>
Re: max_slot_wal_keep_size and wal_keep_segments Fujii Masao <masao.fujii@oss.nttdata.com>
Re: max_slot_wal_keep_size and wal_keep_segments Alvaro Herrera <alvherre@2ndquadrant.com>
Re: max_slot_wal_keep_size and wal_keep_segments David Steele <david@pgmasters.net>
Re: max_slot_wal_keep_size and wal_keep_segments Fujii Masao <masao.fujii@oss.nttdata.com>
Re: max_slot_wal_keep_size and wal_keep_segments Alvaro Herrera <alvherre@2ndquadrant.com>
Re: max_slot_wal_keep_size and wal_keep_segments Fujii Masao <masao.fujii@oss.nttdata.com>
Re: max_slot_wal_keep_size and wal_keep_segments Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: max_slot_wal_keep_size and wal_keep_segments Fujii Masao <masao.fujii@oss.nttdata.com>
Re: max_slot_wal_keep_size and wal_keep_segments Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: max_slot_wal_keep_size and wal_keep_segments Fujii Masao <masao.fujii@oss.nttdata.com>
Re: max_slot_wal_keep_size and wal_keep_segments David Steele <david@pgmasters.net>
Re: max_slot_wal_keep_size and wal_keep_segments Fujii Masao <masao.fujii@oss.nttdata.com>
Re: max_slot_wal_keep_size and wal_keep_segments David Steele <david@pgmasters.net>
Re: max_slot_wal_keep_size and wal_keep_segments Fujii Masao <masao.fujii@oss.nttdata.com>
Re: max_slot_wal_keep_size and wal_keep_segments Fujii Masao <masao.fujii@oss.nttdata.com>
Re: max_slot_wal_keep_size and wal_keep_segments David Steele <david@pgmasters.net>
Re: max_slot_wal_keep_size and wal_keep_segments Fujii Masao <masao.fujii@oss.nttdata.com>
Re: max_slot_wal_keep_size and wal_keep_segments Masahiko Sawada <masahiko.sawada@2ndquadrant.com>
Hi,

When I talked about max_slot_wal_keep_size as new feature in v13
at the conference, I received the question like "Why are the units of
setting values in max_slot_wal_keep_size and wal_keep_segments different?"
from audience. That difference looks confusing for users and
IMO it's better to use the same unit for them. Thought?

There seem to be several options to do this.

(1) Rename max_slot_wal_keep_size to max_slot_wal_keep_segments,
     and make users specify the number of WAL segments in it instead of
     WAL size.

(2) Rename wal_keep_segments to wal_keep_size, and make users specify
      the WAL size in it instead of the number of WAL segments.

(3) Don't rename the parameters, and allow users to specify not only
     the number of WAL segments but also the WAL size in wal_keep_segments.

Since we have been moving away from measuring in segments, e.g.,
max_wal_size, I don't think (1) is good idea.

For backward compatibility, (3) is better. But which needs more
(maybe a bit complicated) code in guc.c. Also the parameter names
are not consistent yet (i.e., _segments and _size).

So for now I like (2).

Thought?

Regards,

-- 
Fujii Masao
Advanced Computing Technology Center
Research and Development Headquarters
NTT DATA CORPORATION


В списке pgsql-hackers по дате отправления
От: Fujii Masao
Дата:
От: Fabien COELHO
Дата:
FAQ