Re: Remove the comment on the countereffectiveness of large shared_buffers on Windows

From: Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>
To: "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>
Cc: Magnus Hagander <magnus(at)hagander(dot)net>, Jeff Janes <jeff(dot)janes(at)gmail(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Remove the comment on the countereffectiveness of large shared_buffers on Windows
Date: 2016-11-21 12:54:03
Message-ID: CAA4eK1+8Tq5vHO=91=muBTgPqAp1PbnvJ0ctn6fX+6=g2+7VbA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Nov 21, 2016 at 7:46 AM, Tsunakawa, Takayuki
<tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com> wrote:
> From: pgsql-hackers-owner(at)postgresql(dot)org
>> [mailto:pgsql-hackers-owner(at)postgresql(dot)org] On Behalf Of Amit Kapila
>> > shared_buffers tps
>> > 256MB 990
>> > 512MB 813
>> > 1GB 1189
>> > 2GB 2258
>> > 4GB 5003
>> > 8GB 5062
>> >
>> > "512MB is the largest effective size" seems to be a superstition, although
>> I don't know the reason for the drop at 512MB.
>> >

Okay, not an issue. I think above data indicates that we can remove
512MB limit for Windows from docs.

--
With Regards,
Amit Kapila.
EnterpriseDB: http://www.enterprisedb.com

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andreas Karlsson 2016-11-21 12:57:22 Re: Contains and is contained by operators of inet datatypes
Previous Message Amit Kapila 2016-11-21 12:40:16 Re: [sqlsmith] Failed assertion in parallel worker in ExecInitSubPlan