From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
---|---|
To: | 'Bruce Momjian' <bruce(at)momjian(dot)us>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: PG 10 release notes |
Date: | 2017-09-19 19:21:06 |
Message-ID: | 7058454c-d4bc-6d3e-7641-48f35a644447@commandprompt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On 09/19/2017 09:32 AM, 'Bruce Momjian' wrote:
> On Tue, Sep 19, 2017 at 12:30:01PM -0400, Tom Lane wrote:
>> "'Bruce Momjian'" <bruce(at)momjian(dot)us> writes:
>>> On Tue, Sep 19, 2017 at 12:22:39PM -0400, Tom Lane wrote:
>>>> We don't normally release-note documentation changes. If this
>>>> wasn't purely a documentation change, then I was probably in error
>>>> to decide it didn't need to be in the notes.
>>
>>> It was purely a documentation change, but it was a documented change in a
>>> long-standing and popular practice of not using too many shared buffers
>>> on Windows, so I thought it wise to add it.
>>
>> Well, if the intent of the note was to encourage people to raise
>> shared_buffers, it didn't do a very good job of that as written,
>> because I sure didn't understand it that way.
>
> Do you have any suggestions since it is not a code change that I can
> point to? My guess is that the limitation was removed years ago, but we
> only found out recently.
My guess is that the limitation was removed as of 9.3 with the work Haas
did with shared buffers. Thus, yes it was years ago. I think that
listing it regardless of the documentation change could be useful.
Something like:
"""
Better support for large shared_buffers configurations including the
Windows platform. Users are encouraged to review their shared_buffer
settings against the size of their active data set and reconfigure
appropriately.
"""
It is pretty much practitioner given that if your active data set can
fit in shared_buffers and you aren't going to adversely affect the
ability for the system to operate, that you should configure a high
setting. I have seen settings as much as 96GB doing wonderfully in
production.
JD
>
--
Command Prompt, Inc. || http://the.postgres.company/ || @cmdpromptinc
PostgreSQL Centered full stack support, consulting and development.
Advocate: @amplifypostgres || Learn: https://pgconf.us
***** Unless otherwise stated, opinions are my own. *****
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2017-09-19 19:21:26 | Re: Re: [COMMITTERS] pgsql: Add citext_pattern_ops for citext contrib module |
Previous Message | Andres Freund | 2017-09-19 19:20:32 | Re: pgsql: Make new crash restart test a bit more robust. |