Postgres Pro
Downloads
Home   >   mailing lists

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

From Peter Eisentraut
Subject Re: Remove the comment on the countereffectiveness of large shared_buffers on Windows
Date
Msg-id 32cba1e7-d4a2-c292-3bf8-6ff46d09b7f7@2ndquadrant.com
Whole thread Raw
In response to Re: Remove the comment on the countereffectiveness of large shared_buffers on Windows  ("Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>)
Responses Re: Remove the comment on the countereffectiveness of large shared_buffers on Windows
List pgsql-hackers
Tree view 
On 11/17/16 12:30 AM, Tsunakawa, Takayuki wrote:
> No, I'm not recommending a higher value, but just removing the doubtful sentences of 512MB upper limit.  The
advantageis that eliminating this sentence will make a chance for users to try best setting.
 

I think this is a good point.  The information is clearly
wrong/outdated.  We have no new better information, but we should remove
misleading outdated advice and let users find new advice.  Basically,
this just puts Windows on par with other platforms with regard to
shared_buffers tuning, doesn't it?

I'm inclined to commit the original patch if there are no objections.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Tuple count used while costing MergeAppend and that for an append rel
Next
From: Robert Haas
Date:
Subject: Re: Mail thread references in commits