Re: [GENERAL]Understanding “max_wal_size” and “min_wal_size” parameters default values from postgresql.conf file

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [GENERAL]Understanding “max_wal_size” and “min_wal_size” parameters default values from postgresql.conf file
Дата
Msg-id 11310.1475523980@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Understanding “max_wal_size” and “min_wal_size” parameters default values from postgresql.conf file  (otar shavadze <oshavadze@gmail.com>)
Ответы Re: [GENERAL] Understanding “max_wal_size” and “min_wal_size” parameters default values from postgresql.conf file  (otar shavadze <oshavadze@gmail.com>)
Список pgsql-general
otar shavadze <oshavadze@gmail.com> writes:
> name         |  setting | unit----------------------------------
> max_wal_size | 64       |
> min_wal_size | 5        |

> I have 2 questions:

> 1) Why these values doesn't match default values, which are shown in docs?
> I never changed config settings at all.

They do match the defaults.

> 2) Why unit column is empty/NULL for these parameters? What means 64 and 5
> values in this case? MB? GB? or what?

The problem seems to be that somebody missed out adding GUC_UNIT_XSEGS
to the switch in GetConfigOptionByNum.  It should be showing you
something like "16MB" in the unit column, I think.

            regards, tom lane


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

Предыдущее
От: Edson Richter
Дата:
Сообщение: Installing pgAdmin 4 in Oracle Enterprise Linux 7
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Problems with pg_upgrade after change of unix user running db.