Re: backend_flush_after bytes/pages

From: Дилян Палаузов <dilyan(dot)palauzov(at)aegee(dot)org>
To: Andres Freund <andres(at)anarazel(dot)de>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: backend_flush_after bytes/pages
Date: 2017-02-07 19:21:58
Message-ID: 27193232-f993-147f-4c07-8182d64c7611@aegee.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hello,

does
backend_flush_after = 7
mean 7 bytes or seven pages? https://www.postgresql.org/docs/9.6/static/runtime-config-resource.html#GUC-BACKEND-FLUSH-AFTER suggests it means 7 bytes, which is not the reality. The documentation is misleading.

Greetings
Dilian

On 02/07/17 19:57, Andres Freund wrote:
> Hi,
>
> On 2017-02-07 19:40:45 +0100, Дилян Палаузов wrote:
>> doc/src/smgl/config.sgml: line 2049 for postgres 9.6 states: "Whenever more than backend_flush_after bytes have been written...", which suggests that the data is interpreted as bytes. However the by initdb generated postgresql.conf file mentions that backend_flush_after is in pages, and pg_settings says the unit is 8kB.
>
>> Please rephrase doc/src/smgl/config.sgml to state, that the unit for
>> backend_flush_after is not bytes, but pages.
>
> You can configure it in bytes though, so I don't really think that
> matters?
>
> Regards,
>
> Andres
>
>

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Andres Freund 2017-02-07 19:28:48 Re: backend_flush_after bytes/pages
Previous Message Kevin Grittner 2017-02-07 19:16:10 Re: data inconsistency between client and server at pg_ctl stop -m fast