Re: Remove the comment on the countereffectiveness of large shared_buffers on Windows - Mailing list pgsql-hackers

From Tsunakawa, Takayuki
Subject Re: Remove the comment on the countereffectiveness of large shared_buffers on Windows
Date
Msg-id 0A3221C70F24FB45833433255569204D1F63E05E@G01JPEXMBYT05
Whole thread Raw
In response to Re: Remove the comment on the countereffectiveness of large shared_buffers on Windows  (Magnus Hagander <magnus@hagander.net>)
Responses Re: Remove the comment on the countereffectiveness of large shared_buffers on Windows
List pgsql-hackers
From: pgsql-hackers-owner@postgresql.org
> [mailto:pgsql-hackers-owner@postgresql.org] On Behalf Of Magnus HaganderOkay and I think partially it might be
becausewe don't have
 
> writeback
>     optimization (done in 9.6) for Windows.  However, still the broader
>     question stands that whether above data is sufficient to say that
> we
>     can recommend the settings of shared_buffers on Windows similar
> to
>     Linux?
> 
> 
> 
> 
> Based on this optimization we might want to keep the text that says large
> shared buffers on Windows aren't as effective perhaps, and just remove the
> sentence that explicitly says don't go over 512MB?

Just removing the reference to the size would make users ask a question "What size is the effective upper limit?"

Regards
Takayuki Tsunakawa


pgsql-hackers by date:

Previous
From: Jan de Visser
Date:
Subject: Re: Do we need use more meaningful variables to replace 0 in catalog head files?
Next
From: Michael Paquier
Date:
Subject: Re: Shared memory estimation for postgres