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

From: otar shavadze <oshavadze(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org
Subject: Re: [GENERAL] Understanding “max_wal_size” and “min_wal_size” parameters default values from postgresql.conf file
Date: 2016-10-03 20:16:36
Message-ID: CAG-jOyD3KrEbWvDL1cnVffho+dGgUvwhHL8p3uTU0zBWKzFnPQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Thank you very much

On Mon, Oct 3, 2016 at 11:46 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> otar shavadze <oshavadze(at)gmail(dot)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
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2016-10-03 21:36:50 Re: isnull() function in pgAdmin3
Previous Message Raymond O'Donnell 2016-10-03 20:09:15 Re: isnull() function in pgAdmin3

Browse pgsql-hackers by date

  From Date Subject
Next Message Pavel Stehule 2016-10-03 20:18:08 Re: Showing parallel status in \df+
Previous Message Tom Lane 2016-10-03 20:03:31 Re: Showing parallel status in \df+