pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedremove shmmax example in Linux section
4+ messages / 4 participants
[nested] [flat]
* remove shmmax example in Linux section
@ 2017-07-21 10:18 gorka.gil@openbravo.com
0 siblings, 1 reply; 4+ messages in thread
From: gorka.gil@openbravo.com @ 2017-07-21 10:18 UTC (permalink / raw)
To: pgsql-docs
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/9.5/static/kernel-resources.html
Description:
Hi,
I'm refer to this document:
https://www.postgresql.org/docs/9.5/static/kernel-resources.html
In "Linux" section, show an example of setting shmmax to 16GB, when this
change is not needed from pg 9.3.
Maybe just remove to avoid confusion?
Maybe also shmall also not needed ?
Regards,
Gorka
--
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: remove shmmax example in Linux section
@ 2017-07-31 18:32 Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
parent: gorka.gil@openbravo.com
0 siblings, 1 reply; 4+ messages in thread
From: Peter Eisentraut @ 2017-07-31 18:32 UTC (permalink / raw)
To: gorka.gil@openbravo.com; pgsql-docs
On 7/21/17 06:18, gorka.gil@openbravo.com wrote:
> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/9.5/static/kernel-resources.html
> Description:
>
> Hi,
>
> I'm refer to this document:
> https://www.postgresql.org/docs/9.5/static/kernel-resources.html
>
> In "Linux" section, show an example of setting shmmax to 16GB, when this
> change is not needed from pg 9.3.
>
> Maybe just remove to avoid confusion?
> Maybe also shmall also not needed ?
It's still needed in some cases, so I don't see why we can't have an
example.
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
--
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: remove shmmax example in Linux section
@ 2017-07-31 18:48 Tom Lane <tgl@sss.pgh.pa.us>
parent: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
0 siblings, 1 reply; 4+ messages in thread
From: Tom Lane @ 2017-07-31 18:48 UTC (permalink / raw)
To: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>; +Cc: gorka.gil@openbravo.com; pgsql-docs
Peter Eisentraut <peter.eisentraut@2ndquadrant.com> writes:
> On 7/21/17 06:18, gorka.gil@openbravo.com wrote:
>> In "Linux" section, show an example of setting shmmax to 16GB, when this
>> change is not needed from pg 9.3.
>>
>> Maybe just remove to avoid confusion?
>> Maybe also shmall also not needed ?
> It's still needed in some cases, so I don't see why we can't have an
> example.
I wonder whether it'd make sense to recast those examples as increasing
semaphore-related settings, as that's much more likely to be needed these
days. I had to boost the SEMMNI setting on my workstation just last week.
(Admittedly, I had something like a dozen postmasters going, but still,
that was an actual change I had to make.) It'd be particularly valuable
to document this for Linux, with its opaque "kernel.sem" API for the
semaphore limits.
regards, tom lane
--
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: remove shmmax example in Linux section
@ 2017-07-31 18:58 Scott Marlowe <scott.marlowe@gmail.com>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 4+ messages in thread
From: Scott Marlowe @ 2017-07-31 18:58 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>; pgsql-docs
On Mon, Jul 31, 2017 at 11:48 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Peter Eisentraut <peter.eisentraut@2ndquadrant.com> writes:
>> On 7/21/17 06:18, gorka.gil@openbravo.com wrote:
>>> In "Linux" section, show an example of setting shmmax to 16GB, when this
>>> change is not needed from pg 9.3.
>>>
>>> Maybe just remove to avoid confusion?
>>> Maybe also shmall also not needed ?
>
>> It's still needed in some cases, so I don't see why we can't have an
>> example.
>
> I wonder whether it'd make sense to recast those examples as increasing
> semaphore-related settings, as that's much more likely to be needed these
> days. I had to boost the SEMMNI setting on my workstation just last week.
> (Admittedly, I had something like a dozen postmasters going, but still,
> that was an actual change I had to make.) It'd be particularly valuable
> to document this for Linux, with its opaque "kernel.sem" API for the
> semaphore limits.
Agreed. I ran into this many years ago with multiple clusters on a box
and it is definitely non-obvious.
--
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2017-07-31 18:58 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2017-07-21 10:18 remove shmmax example in Linux section gorka.gil@openbravo.com
2017-07-31 18:32 ` Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
2017-07-31 18:48 ` Tom Lane <tgl@sss.pgh.pa.us>
2017-07-31 18:58 ` Scott Marlowe <scott.marlowe@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox