You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
<
8000
script type="application/json" data-target="react-app.embeddedData">{"payload":{"commit":{"oid":"3d21f08bccd316c3850a1943c1ee1e381dab1588","url":"/postgres/postgres/commit/3d21f08bccd316c3850a1943c1ee1e381dab1588","authoredDate":"2016-10-10T15:11:33.000-04:00","committedDate":"2016-10-10T16:59:35.000-04:00","shortMessage":null,"shortMessageMarkdown":"\u003cdiv\u003eUpdate user docs for switch to POSIX semaphores.\u003c/div\u003e","shortMessageMarkdownLink":null,"bodyMessageHtml":"Since commit \u003ca class=\"commit-link\" data-hovercard-type=\"commit\" data-hovercard-url=\"https://github.com/postgres/postgres/commit/ecb0d20a9d2e09b7112d3b192047f711f9ff7e59/hovercard\" href=\"https://github.com/postgres/postgres/commit/ecb0d20a9d2e09b7112d3b192047f711f9ff7e59\"\u003e\u003ctt\u003eecb0d20\u003c/tt\u003e\u003c/a\u003e hasn't crashed and burned, here's the promised\ndocs update for it.\n\nIn addition to explaining that Linux and FreeBSD ports now use POSIX\nsemaphores, I did some wordsmithing on pre-existing wording; in\nparticular trying to clarify which SysV parameters need to be set with\nan eye to total usage across all applications.","authors":[{"login":"tglsfdc","displayName":"Tom Lane","avatarUrl":"https://avatars.githubusercontent.com/u/8755309?v=4","path":"/tglsfdc","isGitHub":false}],"committerAttribution":false,"committer":{"login":"tglsfdc","displayName":"Tom Lane","avatarUrl":"https://avatars.githubusercontent.com/u/8755309?v=4","path":"/tglsfdc","isGitHub":false},"parents":["0137caf273f4297c4d36df3a542d7c0c853e75be"],"globalRelayId":"MDY6Q29tbWl0OTI3NDQyOjNkMjFmMDhiY2NkMzE2YzM4NTBhMTk0M2MxZWUxZTM4MWRhYjE1ODg=","sha1":"0137caf273f4297c4d36df3a542d7c0c853e75be","sha2":"3d21f08bccd316c3850a1943c1ee1e381dab1588"},"currentUser":null,"repo":{"id":927442,"defaultBranch":"master","name":"postgres","ownerLogin":"postgres","currentUserCanPush":false,"isFork":false,"isEmpty":false,"createdAt":"2010-09-21T11:35:45.000Z","ownerAvatar":"https://avatars.githubusercontent.com/u/177543?v=4","public":true,"private":false,"isOrgOwned":true},"diffEntryData":[{"diffLines":[{"stylingDirective":null,"type":"HUNK","blobLineNumber":604,"text":"@@ -605,27 +605,47 @@ psql: could not connect to server: No such file or directory","html":"@@ -605,27 +605,47 @@ psql: could not connect to server: No such file or directory","displayNoNewLineWarning":false,"position":0,"left":604,"right":604},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":605,"text":" \u003c/indexterm\u003e","html":" \u0026lt;/indexterm\u0026gt;","displayNoNewLineWarning":false,"position":1,"left":605,"right":605},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":606,"text":" ","html":"\u003cbr\u003e","displayNoNewLineWarning":false,"position":2,"left":606,"right":606},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":607,"text":" \u003cpara\u003e","html":" \u0026lt;para\u0026gt;","displayNoNewLineWarning":false,"position":3,"left":607,"right":607},{"stylingDirective":null,"type":"DELETION","blobLineNumber":608,"text":"- Shared memory and semaphores are collectively referred to as","html":"- Shared memory and semaphores are collectively referred to as","displayNoNewLineWarning":false,"position":4,"left":608,"right":607},{"stylingDirective":null,"type":"DELETION","blobLineNumber":609,"text":"- \u003cquote\u003e\u003csystemitem class=\"osname\"\u003eSystem V\u003c/\u003e","html":"- \u0026lt;quote\u0026gt;\u0026lt;systemitem class=\u0026quot;osname\u0026quot;\u0026gt;System V\u0026lt;/\u0026gt;","displayNoNewLineWarning":false,"position":5,"left":609,"right":607},{"stylingDirective":null,"type":"DELETION","blobLineNumber":610,"text":"- \u003cacronym\u003eIPC\u003c/\u003e\u003c/quote\u003e (together with message queues, which are not","html":"- \u0026lt;acronym\u0026gt;IPC\u0026lt;/\u0026gt;\u0026lt;/quote\u0026gt; (together with message queues, which are not","displayNoNewLineWarning":false,"position":6,"left":610,"right":607},{"stylingDirective":null,"type":"DELETION","blobLineNumber":611,"text":"- relevant for \u003cproductname\u003ePostgreSQL\u003c/\u003e). Except on","html":"- relevant for \u0026lt;productname\u0026gt;PostgreSQL\u0026lt;/\u0026gt;). Except on","displayNoNewLineWarning":false,"position":7,"left":611,"right":607},{"stylingDirective":null,"type":"DELETION","blobLineNumber":612,"text":"- \u003csystemitem class=\"osname\"\u003eWindows\u003c/\u003e, where \u003cproductname\u003ePostgreSQL\u003c/\u003e","html":"- \u0026lt;systemitem class=\u0026quot;osname\u0026quot;\u0026gt;Windows\u0026lt;/\u0026gt;, where \u0026lt;productname\u0026gt;PostgreSQL\u0026lt;/\u0026gt;","displayNoNewLineWarning":false,"position":8,"left":612,"right":607},{"stylingDirective":null,"type":"DELETION","blobLineNumber":613,"text":"- provides its own replacement implementation of these facilities, these","html":"- provides its own replacement implementation of these facilities, these","displayNoNewLineWarning":false,"position":9,"left":613,"right":607},{"stylingDirective":null,"type":"DELETION","blobLineNumber":614,"text":"- facilities are required in order to run","html":"- facilities are required in order to run","displayNoNewLineWarning":false,"position":10,"left":614,"right":607},{"stylingDirective":null,"type":"DELETION","blobLineNumber":615,"text":"- \u003cproductname\u003ePostgreSQL\u003c/\u003e.","html":"- \u0026lt;productname\u0026gt;PostgreSQL\u0026lt;/\u0026gt;.","displayNoNewLineWarning":false,"position":11,"left":615,"right":607},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":608,"text":"+ \u003cproductname\u003ePostgreSQL\u003c/\u003e requires the operating system to provide","html":"+ \u0026lt;productname\u0026gt;PostgreSQL\u0026lt;/\u0026gt; requires the operating system to provide","displayNoNewLineWarning":false,"position":12,"left":615,"right":608},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":609,"text":"+ inter-process communication (\u003cacronym\u003eIPC\u003c/\u003e) features, specifically","html":"+ inter-process communication (\u0026lt;acronym\u0026gt;IPC\u0026lt;/\u0026gt;) features, specifically","displayNoNewLineWarning":false,"position":13,"left":615,"right":609},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":610,"text":"+ shared memory and semaphores. Unix-derived systems typically provide","html":"+ shared memory and semaphores. Unix-derived systems typically provide","displayNoNewLineWarning":false,"position":14,"left":615,"right":610},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":611,"text":"+ \u003cquote\u003e\u003csystemitem class=\"osname\"\u003eSystem V\u003c/\u003e\u003c/\u003e \u003cacronym\u003eIPC\u003c/\u003e,","html":"+ \u0026lt;quote\u0026gt;\u0026lt;systemitem class=\u0026quot;osname\u0026quot;\u0026gt;System V\u0026lt;/\u0026gt;\u0026lt;/\u0026gt; \u0026lt;acronym\u0026gt;IPC\u0026lt;/\u0026gt;,","displayNoNewLineWarning":false,"position":15,"left":615,"right":611},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":612,"text":"+ \u003cquote\u003e\u003csystemitem class=\"osname\"\u003ePOSIX\u003c/\u003e\u003c/\u003e \u003cacronym\u003eIPC\u003c/\u003e, or both.","html":"+ \u0026lt;quote\u0026gt;\u0026lt;systemitem class=\u0026quot;osname\u0026quot;\u0026gt;POSIX\u0026lt;/\u0026gt;\u0026lt;/\u0026gt; \u0026lt;acronym\u0026gt;IPC\u0026lt;/\u0026gt;, or both.","displayNoNewLineWarning":false,"position":16,"left":615,"right":612},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":613,"text":"+ \u003csystemitem class=\"osname\"\u003eWindows\u003c/\u003e has its own implementation of","html":"+ \u0026lt;systemitem class=\u0026quot;osname\u0026quot;\u0026gt;Windows\u0026lt;/\u0026gt; has its own implementation of","displayNoNewLineWarning":false,"position":17,"left":615,"right":613},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":614,"text":"+ these features and is not discussed here.","html":"+ these features and is not discussed here.","displayNoNewLineWarning":false,"position":18,"left":615,"right":614},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":615,"text":" \u003c/para\u003e","html":" \u0026lt;/para\u0026gt;","displayNoNewLineWarning":false,"position":19,"left":616,"right":615},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":616,"text":" ","html":"\u003cbr\u003e","displayNoNewLineWarning":false,"position":20,"left":617,"right":616},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":617,"text":" \u003cpara\u003e","html":" \u0026lt;para\u0026gt;","displayNoNewLineWarning":false,"position":21,"left":618,"right":617},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":618,"text":" The complete lack of these facilities is usually manifested by an","html":" The complete lack of these facilities is usually manifested by an","displayNoNewLineWarning":false,"position":22,"left":619,"right":618},{"stylingDirective":null,"type":"DELETION","blobLineNumber":620,"text":"- \u003cerrorname\u003eIllegal system call\u003c/\u003e error upon server start. In","html":"- \u0026lt;errorname\u0026gt;Illegal system call\u0026lt;/\u0026gt; error upon server\u003cspan class=\"x x-first x-last\"\u003e start. In\u003c/span\u003e","displayNoNewLineWarning":false,"position":23,"left":620,"right":618},{"stylingDirective":null,"type":"DELETION","blobLineNumber":621,"text":"- that case there is no alternative but to reconfigure your","html":"- that case there is no alternative but to reconfigure your","displayNoNewLineWarning":false,"position":24,"left":621,"right":618},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":619,"text":"+ \u003cquote\u003e\u003cerrorname\u003eIllegal system call\u003c/\u003e\u003c/quote\u003e error upon server","html":"+ \u0026lt;\u003cspan class=\"x x-first x-last\"\u003equote\u0026gt;\u0026lt;\u003c/span\u003eerrorname\u0026gt;Illegal system call\u0026lt;/\u0026gt;\u003cspan class=\"x x-first x-last\"\u003e\u0026lt;/quote\u0026gt;\u003c/span\u003e error upon server","displayNoNewLineWarning":false,"position":25,"left":621,"right":619},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":620,"text":"+ start. In that case there is no alternative but to reconfigure your","html":"+ \u003cspan class=\"x x-first x-last\"\u003estart. In \u003c/span\u003ethat case there is no alternative but to reconfigure your","displayNoNewLineWarning":false,"position":26,"left":621,"right":620},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":621,"text":" kernel. \u003cproductname\u003ePostgreSQL\u003c/\u003e won't work without them.","html":" kernel. \u0026lt;productname\u0026gt;PostgreSQL\u0026lt;/\u0026gt; won\u0026#39;t work without them.","displayNoNewLineWarning":false,"position":27,"left":622,"right":621},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":622,"text":" This situation is rare, however, among modern operating systems.","html":" This situation is rare, however, among modern operating systems.","displayNoNewLineWarning":false,"position":28,"left":623,"right":622},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":623,"text":" \u003c/para\u003e","html":" \u0026lt;/para\u0026gt;","displayNoNewLineWarning":false,"position":29,"left":624,"right":623},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":624,"text":" ","html":"\u003cbr\u003e","displayNoNewLineWarning":false,"position":30,"left":625,"right":624},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":625,"text":" \u003cpara\u003e","html":" \u0026lt;para\u0026gt;","displayNoNewLineWarning":false,"position":31,"left":626,"right":625},{"stylingDirective":null,"type":"DELETION","blobLineNumber":627,"text":"- When \u003cproductname\u003ePostgreSQL\u003c/\u003e exceeds one of the various hard","html":"- When \u0026lt;productname\u0026gt;PostgreSQL\u0026lt;/\u0026gt; exceeds one of the various hard","displayNoNewLineWarning":false,"position":32,"left":627,"right":625},{"stylingDirective":null,"type":"DELETION","blobLineNumber":628,"text":"- \u003cacronym\u003eIPC\u003c/\u003e limits, the server will refuse to start and","html":"- \u0026lt;acronym\u0026gt;IPC\u0026lt;/\u0026gt; limits, the server will refuse to start and","displayNoNewLineWarning":false,"position":33,"left":628,"right":625},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":626,"text":"+ Upon starting the server, \u003cproductname\u003ePostgreSQL\u003c/\u003e normally allocates","html":"+ Upon starting the server, \u0026lt;productname\u0026gt;PostgreSQL\u0026lt;/\u0026gt; normally allocates","displayNoNewLineWarning":false,"position":34,"left":628,"right":626},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":627,"text":"+ a very small amount of System V shared memory, as well as a much larger","html":"+ a very small amount of System V shared memory, as well as a much larger","displayNoNewLineWarning":false,"position":35,"left":628,"right":627},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":628,"text":"+ amount of POSIX (\u003cfunction\u003emmap\u003c/\u003e) shared memory.","html":"+ amount of POSIX (\u0026lt;function\u0026gt;mmap\u0026lt;/\u0026gt;) shared memory.","displayNoNewLineWarning":false,"position":36,"left":628,"right":628},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":629,"text":"+ In addition a significant number of semaphores, which can be either","html":"+ In addition a significant number of semaphores, which can be either","displayNoNewLineWarning":false,"position":37,"left":628,"right":629},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":630,"text":"+ System V or POSIX style, are created at server startup. Currently,","html":"+ System V or POSIX style, are created at server startup. Currently,","displayNoNewLineWarning":false,"position":38,"left":628,"right":630},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":631,"text":"+ POSIX semaphores are used on Linux and FreeBSD systems while other","html":"+ POSIX semaphores are used on Linux and FreeBSD systems while other","displayNoNewLineWarning":false,"position":39,"left":628,"right":631},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":632,"text":"+ platforms use System V semaphores.","html":"+ platforms use System V semaphores.","displayNoNewLineWarning":false,"position":40,"left":628,"right":632},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":633,"text":"+ \u003c/para\u003e","html":"+ \u0026lt;/para\u0026gt;","displayNoNewLineWarning":false,"position":41,"left":628,"right":633},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":634,"text":"+","html":"+","displayNoNewLineWarning":false,"position":42,"left":628,"right":634},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":635,"text":"+ \u003cnote\u003e","html":"+ \u0026lt;note\u0026gt;","displayNoNewLineWarning":false,"position":43,"left":628,"right":635},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":636,"text":"+ \u003cpara\u003e","html":"+ \u0026lt;para\u0026gt;","displayNoNewLineWarning":false,"position":44,"left":628,"right":636},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":637,"text":"+ Prior to \u003cproductname\u003ePostgreSQL\u003c/\u003e 9.3, only System V shared memory","html":"+ Prior to \u0026lt;productname\u0026gt;PostgreSQL\u0026lt;/\u0026gt; 9.3, only System V shared memory","displayNoNewLineWarning":false,"position":45,"left":628,"right":637},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":638,"text":"+ was used, so the amount of System V shared memory required to start the","html":"+ was used, so the amount of System V shared memory required to start the","displayNoNewLineWarning":false,"position":46,"left":628,"right":638},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":639,"text":"+ server was much larger. If you are running an older version of the","html":"+ server was much larger. If you are running an older version of the","displayNoNewLineWarning":false,"position":47,"left":628,"right":639},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":640,"text":"+ server, please consult the documentation for your server version.","html":"+ server, please consult the documentation for your server version.","displayNoNewLineWarning":false,"position":48,"left":628,"right":640},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":641,"text":"+ \u003c/para\u003e","html":"+ \u0026lt;/para\u0026gt;","displayNoNewLineWarning":false,"position":49,"left":628,"right":641},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":642,"text":"+ \u003c/note\u003e","html":"+ \u0026lt;/note\u0026gt;","displayNoNewLineWarning":false,"position":50,"left":628,"right":642},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":643,"text":"+","html":"+","displayNoNewLineWarning":false,"position":51,"left":628,"right":643},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":644,"text":"+ \u003cpara\u003e","html":"+ \u0026lt;para\u0026gt;","displayNoNewLineWarning":false,"position":52,"left":628,"right":644},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":645,"text":"+ System V \u003cacronym\u003eIPC\u003c/\u003e features are typically constrained by","html":"+ System V \u0026lt;acronym\u0026gt;IPC\u0026lt;/\u0026gt; features are typically constrained by","displayNoNewLineWarning":false,"position":53,"left":628,"right":645},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":646,"text":"+ system-wide allocation limits.","html":"+ system-wide allocation limits.","displayNoNewLineWarning":false,"position":54,"left":628,"right":646},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":647,"text":"+ When \u003cproductname\u003ePostgreSQL\u003c/\u003e exceeds one of these limits,","html":"+ When \u0026lt;productname\u0026gt;PostgreSQL\u0026lt;/\u0026gt; exceeds one of these limits,","displayNoNewLineWarning":false,"position":55,"left":628,"right":647},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":648,"text":"+ the server will refuse to start and","html":"+ the server will refuse to start and","displayNoNewLineWarning":false,"position":56,"left":628,"right":648},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":649,"text":" should leave an instructive error message describing the problem","html":" should leave an instructive error message describing the problem","displayNoNewLineWarning":false,"position":57,"left":629,"right":649},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":650,"text":" and what to do about it. (See also \u003cxref","html":" and what to do about it. (See also \u0026lt;xref","displayNoNewLineWarning":false,"position":58,"left":630,"right":650},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":651,"text":" linkend=\"server-start-failures\"\u003e.) The relevant kernel","html":" linkend=\u0026quot;server-start-failures\u0026quot;\u0026gt;.) The relevant kernel","displayNoNewLineWarning":false,"position":59,"left":631,"right":651},{"stylingDirective":null,"type":"HUNK","blobLineNumber":653,"text":"@@ -634,15 +654,6 @@ psql: could not connect to server: No such file or directory","html":"@@ -634,15 +654,6 @@ psql: could not connect to server: No such file or directory","displayNoNewLineWarning":false,"position":60,"left":633,"right":653},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":654,"text":" them, however, vary. Suggestions for some platforms are given below.","html":" them, however, vary. Suggestions for some platforms are given below.","displayNoNewLineWarning":false,"position":61,"left":634,"right":654},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":655,"text":" \u003c/para\u003e","html":" \u0026lt;/para\u0026gt;","displayNoNewLineWarning":false,"position":62,"left":635,"right":655},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":656,"text":" ","html":"\u003cbr\u003e","displayNoNewLineWarning":false,"position":63,"left":636,"right":656},{"stylingDirective":null,"type":"DELETION","blobLineNumber":637,"text":"- \u003cnote\u003e","html":"- \u0026lt;note\u0026gt;","displayNoNewLineWarning":false,"position":64,"left":637,"right":656},{"stylingDirective":null,"type":"DELETION","blobLineNumber":638,"text":"- \u003cpara\u003e","html":"- \u0026lt;para\u0026gt;","displayNoNewLineWarning":false,"position":65,"left":638,"right":656},{"stylingDirective":null,"type":"DELETION","blobLineNumber":639,"text":"- Prior to \u003cproductname\u003ePostgreSQL\u003c/\u003e 9.3, the amount of System V shared","html":"- Prior to \u0026lt;productname\u0026gt;PostgreSQL\u0026lt;/\u0026gt; 9.3, the amount of System V shared","displayNoNewLineWarning":false,"position":66,"left":639,"right":656},{"stylingDirective":null,"type":"DELETION","blobLineNumber":640,"text":"- memory required to start the server was much larger. If you are running","html":"- memory required to start the server was much larger. If you are running","displayNoNewLineWarning":false,"position":67,"left":640,"right":656},{"stylingDirective":null,"type":"DELETION","blobLineNumber":641,"text":"- an older version of the server, please consult the documentation for","html":"- an older version of the server, please consult the documentation for","displayNoNewLineWarning":false,"position":68,"left":641,"right":656},{"stylingDirective":null,"type":"DELETION","blobLineNumber":642,"text":"- your server version.","html":"- your server version.","displayNoNewLineWarning":false,"position":69,"left":642,"right":656},{"stylingDirective":null,"type":"DELETION","blobLineNumber":643,"text":"- \u003c/para\u003e","html":"- \u0026lt;/para\u0026gt;","displayNoNewLineWarning":false,"position":70,"left":643,"right":656},{"stylingDirective":null,"type":"DELETION","blobLineNumber":644,"text":"- \u003c/note\u003e","html":"- \u0026lt;/note\u0026gt;","displayNoNewLineWarning":false,"position":71,"left":644,"right":656},{"stylingDirective":null,"type":"DELETION","blobLineNumber":645,"text":"-","html":"-","displayNoNewLineWarning":false,"position":72,"left":645,"right":656},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":657,"text":" \u003ctable id=\"sysvipc-parameters\"\u003e","html":" \u0026lt;table id=\u0026quot;sysvipc-parameters\u0026quot;\u0026gt;","displayNoNewLineWarning":false,"position":73,"left":646,"right":657},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":658,"text":" \u003ctitle\u003e\u003csystemitem class=\"osname\"\u003eSystem V\u003c/\u003e \u003cacronym\u003eIPC\u003c/\u003e Parameters\u003c/title\u003e","html":" \u0026lt;title\u0026gt;\u0026lt;systemitem class=\u0026quot;osname\u0026quot;\u0026gt;System V\u0026lt;/\u0026gt; \u0026lt;acronym\u0026gt;IPC\u0026lt;/\u0026gt; Parameters\u0026lt;/title\u0026gt;","displayNoNewLineWarning":false,"position":74,"left":647,"right":658},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":659,"text":" ","html":"\u003cbr\u003e","displayNoNewLineWarning":false,"position":75,"left":648,"right":659},{"stylingDirective":null,"type":"HUNK","blobLineNumber":661,"text":"@@ -651,15 +662,15 @@ psql: could not connect to server: No such file or directory","html":"@@ -651,15 +662,15 @@ psql: could not connect to server: No such file or directory","displayNoNewLineWarning":false,"position":76,"left":650,"right":661},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":662,"text":" \u003crow\u003e","html":" \u0026lt;row\u0026gt;","displayNoNewLineWarning":false,"position":77,"left":651,"right":662},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":663,"text":" \u003centry\u003eName\u003c/\u003e","html":" \u0026lt;entry\u0026gt;Name\u0026lt;/\u0026gt;","displayNoNewLineWarning":false,"position":78,"left":652,"right":663},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":664,"text":" \u003centry\u003eDescription\u003c/\u003e","html":" \u0026lt;entry\u0026gt;Description\u0026lt;/\u0026gt;","displayNoNewLineWarning":false,"position":79,"left":653,"right":664},{"stylingDirective":null,"type":"DELETION","blobLineNumber":654,"text":"- \u003centry\u003eReasonable values\u003c/\u003e","html":"- \u0026lt;entry\u0026gt;\u003cspan class=\"x x-first x-last\"\u003eReasonable values\u003c/span\u003e\u0026lt;/\u0026gt;","displayNoNewLineWarning":false,"position":80,"left":654,"right":664},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":665,"text":"+ \u003centry\u003eValues needed to run one \u003cproductname\u003ePostgreSQL\u003c/\u003e instance\u003c/\u003e","html":"+ \u0026lt;entry\u0026gt;\u003cspan class=\"x x-first x-last\"\u003eValues needed to run one \u0026lt;productname\u0026gt;PostgreSQL\u0026lt;/\u0026gt; instance\u003c/span\u003e\u0026lt;/\u0026gt;","displayNoNewLineWarning":false,"position":81,"left":654,"right":665},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":666,"text":" \u003c/row\u003e","html":" \u0026lt;/row\u0026gt;","displayNoNewLineWarning":false,"position":82,"left":655,"right":666},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":667,"text":" \u003c/thead\u003e","html":" \u0026lt;/thead\u0026gt;","displayNoNewLineWarning":false,"position":83,"left":656,"right":667},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":668,"text":" ","html":"\u003cbr\u003e","displayNoNewLineWarning":false,"position":84,"left":657,"right":668},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":669,"text":" \u003ctbody\u003e","html":" \u0026lt;tbody\u0026gt;","displayNoNewLineWarning":false,"position":85,"left":658,"right":669},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":670,"text":" \u003crow\u003e","html":" \u0026lt;row\u0026gt;","displayNoNewLineWarning":false,"position":86,"left":659,"right":670},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":671,"text":" \u003centry\u003e\u003cvarname\u003eSHMMAX\u003c/\u003e\u003c/\u003e","html":" \u0026lt;entry\u0026gt;\u0026lt;varname\u0026gt;SHMMAX\u0026lt;/\u0026gt;\u0026lt;/\u0026gt;","displayNoNewLineWarning":false,"position":87,"left":660,"right":671},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":672,"text":" \u003centry\u003eMaximum size of shared memory segment (bytes)\u003c/\u003e","html":" \u0026lt;entry\u0026gt;Maximum size of shared memory segment (bytes)\u0026lt;/\u0026gt;","displayNoNewLineWarning":false,"position":88,"left":661,"right":672},{"stylingDirective":null,"type":"DELETION","blobLineNumber":662,"text":"- \u003centry\u003eat least 1kB (more if running many copies of the server)\u003c/entry\u003e","html":"- \u0026lt;entry\u0026gt;at least 1kB\u003cspan class=\"x x-first x-last\"\u003e (more if running many copies of the server)\u003c/span\u003e\u0026lt;/entry\u0026gt;","displayNoNewLineWarning":false,"position":89,"left":662,"right":672},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":673,"text":"+ \u003centry\u003eat least 1kB, but the default is usually much higher\u003c/entry\u003e","html":"+ \u0026lt;entry\u0026gt;at least 1kB\u003cspan class=\"x x-first x-last\"\u003e, but the default is usually much higher\u003c/span\u003e\u0026lt;/entry\u0026gt;","displayNoNewLineWarning":false,"position":90,"left":662,"right":673},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":674,"text":" \u003c/row\u003e","html":" \u0026lt;/row\u0026gt;","displayNoNewLineWarning":false,"position":91,"left":663,"right":674},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":675,"text":" ","html":"\u003cbr\u003e","displayNoNewLineWarning":false,"position":92,"left":664,"right":675},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":676,"text":" \u003crow\u003e","html":" \u0026lt;row\u0026gt;","displayNoNewLineWarning":false,"position":93,"left":665,"right":676},{"stylingDirective":null,"type":"HUNK","blobLineNumber":681,"text":"@@ -671,7 +682,9 @@ psql: could not connect to server: No such file or directory","html":"@@ -671,7 +682,9 @@ psql: could not connect to server: No such file or directory","displayNoNewLineWarning":false,"position":94,"left":670,"right":681},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":682,"text":" \u003crow\u003e","html":" \u0026lt;row\u0026gt;","displayNoNewLineWarning":false,"position":95,"left":671,"right":682},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":683,"text":" \u003centry\u003e\u003cvarname\u003eSHMALL\u003c/\u003e\u003c/\u003e","html":" \u0026lt;entry\u0026gt;\u0026lt;varname\u0026gt;SHMALL\u0026lt;/\u0026gt;\u0026lt;/\u0026gt;","displayNoNewLineWarning":false,"position":96,"left":672,"right":683},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":684,"text":" \u003centry\u003eTotal amount of shared memory available (bytes or pages)\u003c/\u003e","html":" \u0026lt;entry\u0026gt;Total amount of shared memory available (bytes or pages)\u0026lt;/\u0026gt;","displayNoNewLineWarning":false,"position":97,"left":673,"right":684},{"stylingDirective":null,"type":"DELETION","blobLineNumber":674,"text":"- \u003centry\u003eif bytes, same as \u003cvarname\u003eSHMMAX\u003c/varname\u003e; if pages, \u003cliteral\u003eceil(SHMMAX/PAGE_SIZE)\u003c/literal\u003e\u003c/\u003e","html":"- \u0026lt;entry\u0026gt;if bytes, same as \u0026lt;varname\u0026gt;SHMMAX\u0026lt;/varname\u0026gt;; if pages, \u0026lt;literal\u0026gt;ceil(SHMMAX/PAGE_SIZE)\u0026lt;/literal\u0026gt;\u0026lt;/\u0026gt;","displayNoNewLineWarning":false,"position":98,"left":674,"right":684},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":685,"text":"+ \u003centry\u003esame as \u003cvarname\u003eSHMMAX\u003c/varname\u003e if bytes,","html":"+ \u0026lt;entry\u0026gt;same as \u0026lt;varname\u0026gt;SHMMAX\u0026lt;/varname\u0026gt; if bytes,","displayNoNewLineWarning":false,"position":99,"left":674,"right":685},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":686,"text":"+ or \u003cliteral\u003eceil(SHMMAX/PAGE_SIZE)\u003c/literal\u003e if pages,","html":"+ or \u0026lt;literal\u0026gt;ceil(SHMMAX/PAGE_SIZE)\u0026lt;/literal\u0026gt; if pages,","displayNoNewLineWarning":false,"position":100,"left":674,"right":686},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":687,"text":"+ plus room for other applications\u003c/\u003e","html":"+ plus room for other applications\u0026lt;/\u0026gt;","displayNoNewLineWarning":false,"position":101,"left":674,"right":687},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":688,"text":" \u003c/row\u003e","html":" \u0026lt;/row\u0026gt;","displayNoNewLineWarning":false,"position":102,"left":675,"right":688},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":689,"text":" ","html":"\u003cbr\u003e","displayNoNewLineWarning":false,"position":103,"left":676,"right":689},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":690,"text":" \u003crow\u003e","html":" \u0026lt;row\u0026gt;","displayNoNewLineWarning":false,"position":104,"left":677,"right":690},{"stylingDirective":null,"type":"HUNK","blobLineNumber":701,"text":"@@ -689,7 +702,7 @@ psql: could not connect to server: No such file or directory","html":"@@ -689,7 +702,7 @@ psql: could not connect to server: No such file or directory","displayNoNewLineWarning":false,"position":105,"left":688,"right":701},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":702,"text":" \u003crow\u003e","html":" \u0026lt;row\u0026gt;","displayNoNewLineWarning":false,"position":106,"left":689,"right":702},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":703,"text":" \u003centry\u003e\u003cvarname\u003eSEMMNI\u003c/\u003e\u003c/\u003e","html":" \u0026lt;entry\u0026gt;\u0026lt;varname\u0026gt;SEMMNI\u0026lt;/\u0026gt;\u0026lt;/\u0026gt;","displayNoNewLineWarning":false,"position":107,"left":690,"right":703},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":704,"text":" \u003centry\u003eMaximum number of semaphore identifiers (i.e., sets)\u003c/\u003e","html":" \u0026lt;entry\u0026gt;Maximum number of semaphore identifiers (i.e., sets)\u0026lt;/\u0026gt;","displayNoNewLineWarning":false,"position":108,"left":691,"right":704},{"stylingDirecti
8000
ve":null,"type":"DELETION","blobLineNumber":692,"text":"- \u003centry\u003eat least \u003cliteral\u003eceil((max_connections + autovacuum_max_workers + max_worker_processes + 5) / 16)\u003c/literal\u003e\u003c/\u003e","html":"- \u0026lt;entry\u0026gt;at least \u0026lt;literal\u0026gt;ceil((max_connections + autovacuum_max_workers + max_worker_processes + 5) / 16)\u0026lt;/literal\u0026gt;\u0026lt;/\u0026gt;","displayNoNewLineWarning":false,"position":109,"left":692,"right":704},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":705,"text":"+ \u003centry\u003eat least \u003cliteral\u003eceil((max_connections + autovacuum_max_workers + max_worker_processes + 5) / 16)\u003c/literal\u003e plus room for other applications\u003c/\u003e","html":"+ \u0026lt;entry\u0026gt;at least \u0026lt;literal\u0026gt;ceil((max_connections + autovacuum_max_workers + max_worker_processes + 5) / 16)\u0026lt;/literal\u0026gt;\u003cspan class=\"x x-first x-last\"\u003e plus room for other applications\u003c/span\u003e\u0026lt;/\u0026gt;","displayNoNewLineWarning":false,"position":110,"left":692,"right":705},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":706,"text":" \u003c/row\u003e","html":" \u0026lt;/row\u0026gt;","displayNoNewLineWarning":false,"position":111,"left":693,"right":706},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":707,"text":" ","html":"\u003cbr\u003e","displayNoNewLineWarning":false,"position":112,"left":694,"right":707},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":708,"text":" \u003crow\u003e","html":" \u0026lt;row\u0026gt;","displayNoNewLineWarning":false,"position":113,"left":695,"right":708},{"stylingDirective":null,"type":"HUNK","blobLineNumber":737,"text":"@@ -725,9 +738,8 @@ psql: could not connect to server: No such file or directory","html":"@@ -725,9 +738,8 @@ psql: could not connect to server: No such file or directory","displayNoNewLineWarning":false,"position":114,"left":724,"right":737},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":738,"text":" (typically 48 bytes, on 64-bit platforms) for each copy of the server.","html":" (typically 48 bytes, on 64-bit platforms) for each copy of the server.","displayNoNewLineWarning":false,"position":115,"left":725,"right":738},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":739,"text":" On most modern operating systems, this amount can easily be allocated.","html":" On most modern operating systems, this amount can easily be allocated.","displayNoNewLineWarning":false,"position":116,"left":726,"right":739},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":740,"text":" However, if you are running many copies of the server, or if other","html":" However, if you are running many copies of the server, or if other","displayNoNewLineWarning":false,"position":117,"left":727,"right":740},{"stylingDirective":null,"type":"DELETION","blobLineNumber":728,"text":"- applications are also using System V shared memory, it may be necessary","html":"- applications are also using System V shared memory, it may be necessary","displayNoNewLineWarning":false,"position":118,"left":728,"right":740},{"stylingDirective":null,"type":"DELETION","blobLineNumber":729,"text":"- to increase \u003cvarname\u003eSHMMAX\u003c/\u003e, the maximum size in bytes of a shared","html":"- to increase \u0026lt;varname\u0026gt;SHMMAX\u0026lt;/\u0026gt;, the maximum size in bytes of a shared","displayNoNewLineWarning":false,"position":119,"left":729,"right":740},{"stylingDirective":null,"type":"DELETION","blobLineNumber":730,"text":"- memory segment, or \u003cvarname\u003eSHMALL\u003c/\u003e, the total amount of System V shared","html":"- memory segment, or \u0026lt;varname\u0026gt;SHMALL\u0026lt;/\u0026gt;, the total amount of System V shared","displayNoNewLineWarning":false,"position":120,"left":730,"right":740},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":741,"text":"+ applications are also using System V shared memory, it may be necessary to","html":"+ applications are also using System V shared memory, it may be necessary to","displayNoNewLineWarning":false,"position":121,"left":730,"right":741},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":742,"text":"+ increase \u003cvarname\u003eSHMALL\u003c/\u003e, which is the total amount of System V shared","html":"+ increase \u0026lt;varname\u0026gt;SHMALL\u0026lt;/\u0026gt;, which is the total amount of System V shared","displayNoNewLineWarning":false,"position":122,"left":730,"right":742},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":743,"text":" memory system-wide. Note that \u003cvarname\u003eSHMALL\u003c/\u003e is measured in pages","html":" memory system-wide. Note that \u0026lt;varname\u0026gt;SHMALL\u0026lt;/\u0026gt; is measured in pages","displayNoNewLineWarning":false,"position":123,"left":731,"right":743},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":744,"text":" rather than bytes on many systems.","html":" rather than bytes on many systems.","displayNoNewLineWarning":false,"position":124,"left":732,"right":744},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":745,"text":" \u003c/para\u003e","html":" \u0026lt;/para\u0026gt;","displayNoNewLineWarning":false,"position":125,"left":733,"right":745},{"stylingDirective":null,"type":"HUNK","blobLineNumber":753,"text":"@@ -742,6 +754,7 @@ psql: could not connect to server: No such file or directory","html":"@@ -742,6 +754,7 @@ psql: could not connect to server: No such file or directory","displayNoNewLineWarning":false,"position":126,"left":741,"right":753},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":754,"text":" \u003c/para\u003e","html":" \u0026lt;/para\u0026gt;","displayNoNewLineWarning":false,"position":127,"left":742,"right":754},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":755,"text":" ","html":"\u003cbr\u003e","displayNoNewLineWarning":false,"position":128,"left":743,"right":755},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":756,"text":" \u003cpara\u003e","html":" \u0026lt;para\u0026gt;","displayNoNewLineWarning":false,"position":129,"left":744,"right":756},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":757,"text":"+ When using System V semaphores,","html":"+ When using System V semaphores,","displayNoNewLineWarning":false,"position":130,"left":744,"right":757},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":758,"text":" \u003cproductname\u003ePostgreSQL\u003c/\u003e uses one semaphore per allowed connection","html":" \u0026lt;productname\u0026gt;PostgreSQL\u0026lt;/\u0026gt; uses one semaphore per allowed connection","displayNoNewLineWarning":false,"position":131,"left":745,"right":758},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":759,"text":" (\u003cxref linkend=\"guc-max-connections\"\u003e), allowed autovacuum worker process","html":" (\u0026lt;xref linkend=\u0026quot;guc-max-connections\u0026quot;\u0026gt;), allowed autovacuum worker process","displayNoNewLineWarning":false,"position":132,"left":746,"right":759},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":760,"text":" (\u003cxref linkend=\"guc-autovacuum-max-workers\"\u003e) and allowed background","html":" (\u0026lt;xref linkend=\u0026quot;guc-autovacuum-max-workers\u0026quot;\u0026gt;) and allowed background","displayNoNewLineWarning":false,"position":133,"left":747,"right":760},{"stylingDirective":null,"type":"HUNK","blobLineNumber":791,"text":"@@ -779,15 +792,19 @@ psql: could not connect to server: No such file or directory","html":"@@ -779,15 +792,19 @@ psql: could not connect to server: No such file or directory","displayNoNewLineWarning":false,"position":134,"left":778,"right":791},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":792,"text":" \u003c/para\u003e","html":" \u0026lt;/para\u0026gt;","displayNoNewLineWarning":false,"position":135,"left":779,"right":792},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":793,"text":" ","html":"\u003cbr\u003e","displayNoNewLineWarning":false,"position":136,"left":780,"right":793},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":794,"text":" \u003cpara\u003e","html":" \u0026lt;para\u0026gt;","displayNoNewLineWarning":false,"position":137,"left":781,"right":794},{"stylingDirective":null,"type":"DELETION","blobLineNumber":782,"text":"- The \u003cvarname\u003eSEMMSL\u003c/\u003e parameter, which determines how many","html":"- \u003cspan class=\"x x-first x-last\"\u003eThe \u0026lt;varname\u0026gt;SEMMSL\u003c/span\u003e\u0026lt;/\u0026gt;\u003cspan class=\"x x-first x-last\"\u003e parameter, which determines how many\u003c/span\u003e","displayNoNewLineWarning":false,"position":138,"left":782,"right":794},{"stylingDirective":null,"type":"DELETION","blobLineNumber":783,"text":"- semaphores can be in a set, must be at least 17 for","html":"- \u003cspan class=\"x x-first x-last\"\u003esemaphores can be in a set, must be at least 17 for\u003c/span\u003e","displayNoNewLineWarning":false,"position":139,"left":783,"right":794},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":795,"text":"+ Various other settings related to \u003cquote\u003esemaphore undo\u003c/\u003e, such as","html":"+ \u003cspan class=\"x x-first x-last\"\u003eVarious other settings related to \u0026lt;quote\u0026gt;semaphore undo\u003c/span\u003e\u0026lt;/\u0026gt;\u003cspan class=\"x x-first x-last\"\u003e, such as\u003c/span\u003e","displayNoNewLineWarning":false,"position":140,"left":783,"right":795},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":796,"text":"+ \u003cvarname\u003eSEMMNU\u003c/\u003e and \u003cvarname\u003eSEMUME\u003c/\u003e, do not affect","html":"+ \u003cspan class=\"x x-first x-last\"\u003e\u0026lt;varname\u0026gt;SEMMNU\u0026lt;/\u0026gt; and \u0026lt;varname\u0026gt;SEMUME\u0026lt;/\u0026gt;, do not affect\u003c/span\u003e","displayNoNewLineWarning":false,"position":141,"left":783,"right":796},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":797,"text":" \u003cproductname\u003ePostgreSQL\u003c/\u003e.","html":" \u0026lt;productname\u0026gt;PostgreSQL\u0026lt;/\u0026gt;.","displayNoNewLineWarning":false,"position":142,"left":784,"right":797},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":798,"text":" \u003c/para\u003e","html":" \u0026lt;/para\u0026gt;","displayNoNewLineWarning":false,"position":143,"left":785,"right":798},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":799,"text":" ","html":"\u003cbr\u003e","displayNoNewLineWarning":false,"position":144,"left":786,"right":799},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":800,"text":" \u003cpara\u003e","html":" \u0026lt;para\u0026gt;","displayNoNewLineWarning":false,"position":145,"left":787,"right":800},{"stylingDirective":null,"type":"DELETION","blobLineNumber":788,"text":"- Various other settings related to \u003cquote\u003esemaphore undo\u003c/\u003e, such as","html":"- Various other settings related to \u0026lt;quote\u0026gt;semaphore undo\u0026lt;/\u0026gt;, such as","displayNoNewLineWarning":false,"position":146,"left":788,"right":800},{"stylingDirective":null,"type":"DELETION","blobLineNumber":789,"text":"- \u003cvarname\u003eSEMMNU\u003c/\u003e and \u003cvarname\u003eSEMUME\u003c/\u003e, do not affect","html":"- \u0026lt;varname\u0026gt;SEMMNU\u0026lt;/\u0026gt; and \u0026lt;varname\u0026gt;SEMUME\u0026lt;/\u0026gt;, do not affect","displayNoNewLineWarning":false,"position":147,"left":789,"right":800},{"stylingDirective":null,"type":"DELETION","blobLineNumber":790,"text":"- \u003cproductname\u003ePostgreSQL\u003c/\u003e.","html":"- \u0026lt;productname\u0026gt;PostgreSQL\u0026lt;/\u0026gt;.","displayNoNewLineWarning":false,"position":148,"left":790,"right":800},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":801,"text":"+ When using POSIX semaphores, the number of semaphores needed is the","html":"+ When using POSIX semaphores, the number of semaphores needed is the","displayNoNewLineWarning":false,"position":149,"left":790,"right":801},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":802,"text":"+ same as for System V, that is one semaphore per allowed connection","html":"+ same as for System V, that is one semaphore per allowed connection","displayNoNewLineWarning":false,"position":150,"left":790,"right":802},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":803,"text":"+ (\u003cxref linkend=\"guc-max-connections\"\u003e), allowed autovacuum worker process","html":"+ (\u0026lt;xref linkend=\u0026quot;guc-max-connections\u0026quot;\u0026gt;), allowed autovacuum worker process","displayNoNewLineWarning":false,"position":151,"left":790,"right":803},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":804,"text":"+ (\u003cxref linkend=\"guc-autovacuum-max-workers\"\u003e) and allowed background","html":"+ (\u0026lt;xref linkend=\u0026quot;guc-autovacuum-max-workers\u0026quot;\u0026gt;) and allowed background","displayNoNewLineWarning":false,"position":152,"left":790,"right":804},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":805,"text":"+ process (\u003cxref linkend=\"guc-max-worker-processes\"\u003e).","html":"+ process (\u0026lt;xref linkend=\u0026quot;guc-max-worker-processes\u0026quot;\u0026gt;).","displayNoNewLineWarning":false,"position":153,"left":790,"right":805},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":806,"text":"+ On the platforms where this option is preferred, there is no specific","html":"+ On the platforms where this option is preferred, there is no specific","displayNoNewLineWarning":false,"position":154,"left":790,"right":806},{"stylingDirective":null,"type":"ADDITION","blobLineNumber":807,"text":"+ kernel limit on the number of POSIX semaphores.","html":"+ kernel limit on the number of POSIX semaphores.","displayNoNewLineWarning":false,"position":155,"left":790,"right":807},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":808,"text":" \u003c/para\u003e","html":" \u0026lt;/para\u0026gt;","displayNoNewLineWarning":false,"position":156,"left":791,"right":808},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":809,"text":" ","html":"\u003cbr\u003e","displayNoNewLineWarning":false,"position":157,"left":792,"right":809},{"stylingDirective":null,"type":"CONTEXT","blobLineNumber":810,"text":" ","html":"\u003cbr\u003e","displayNoNewLineWarning":false,"position":158,"left":793,"right":810}],"diffNumber":0,"diffSize":"0 Bytes","isBinary":false,"isTooBig":false,"collapsed":false,"isSubmodule":false,"lineCount":2526,"linesChanged":83,"newTreeEntry":{"lineCount":2526,"path":"doc/src/sgml/runtime.sgml","mode":100644,"isGenerated":false},"oldTreeEntry":{"lineCount":0,"path":"doc/src/sgml/runtime.sgml","mode":100644},"linesAdded":50,"linesDeleted":33,"path":"doc/src/sgml/runtime.sgml","pathDigest":"0ba3dcbf477983ce8b8adc15e812ebba3ebcdb5026d2f79f4f6c00181a05351e","status":"MODIFIED","truncatedReason":null,"oldOid":"0137caf273f4297c4d36df3a542d7c0c853e75be","newOid":"3d21f08bccd316c3850a1943c1ee1e381dab1588","copilotChatReference":null,"deletedSha":"0137caf273f4297c4d36df3a542d7c0c853e75be","canToggleRichDiff":false,"defaultToRichDiff":false,"proseDifffHtml":null,"renderInfo":null,"dependencyDiffPath":null,"submodule":null}],"splitViewPreference":"unified","ignoreWhitespace":false,"repoOwnerGlobalRelayId":"MDEyOk9yZ2FuaXphdGlvbjE3NzU0Mw==","commentsPreference":"visible","diffLineSpacingPreference":"relaxed","useMonospaceFont":false,"pasteUrlLinkAsPlainText":false,"userNotices":[],"path":"/postgres/postgres/commit/3d21f08bccd316c3850a1943c1ee1e381dab1588","fileTreeExpanded":true,"headerInfo":{"additions":50,"deletions":33,"filesChanged":1,"filesChangedString":"1"},"moreDiffsToLoad":false,"asyncDiffLoadInfo":{"startIndex":1,"truncated":false,"byteCount":7526,"lineShownCount":159},"commentInfo":{"canComment":false,"locked":false,"canLock":false,"repoArchived":false},"csrf_tokens":{"/users/diffview?diff=split":{"post":"cnHWiXf6fEyFDH5wsVwJyMtTW5uLsptYvasZMODandmGrSJWb4ouFqUSy2qXxOqShWM50EBk6Jqw5wUAX6lHMw"},"/users/diffview?diff=unified":{"post":"M3w22a_lVOobXRR7c59j1sJAx8y8tX4TTFBCkyV_uEbHoMIGt5UGsDtDoWFVB4CMjHClh3djDdFBHF6jmgxirA"},"/notifications/thread":{"post":"0xu5mEhydnpz5cuVHvqaoMjE7gcJrSG3ArbT26BCRVB-y8Iz2I54Y9u_8b7VRc88_LkHDz-IfSLSkiHcm28I-Q"}}},"title":"Update user docs for switch to POSIX semaphores. · postgres/postgres@3d21f08","appPayload":{"helpUrl":"https://docs.github.com","findInDiffWorkerPath":"/assets-cdn/worker/find-in-diff-worker-2bfe39677d14.js","enabled_features":{"diff_ux_refresh_beta":false,"diff_inline_comments":true,"diff_ux_refresh_ssr_five":false,"diff_ux_refresh_ssr_ten":false,"react_diff_line_type_character_correction":true}}}
Since commit ecb0d20 hasn't crashed and burned, here's the promised
docs update for it.
In addition to explaining that Linux and FreeBSD ports now use POSIX
semaphores, I did some wordsmithing on pre-existing wording; in
particular trying to clarify which SysV parameters need to be set with
an eye to total usage across all applications.
<entry>at least <literal>ceil((max_connections + autovacuum_max_workers + max_worker_processes + 5) / 16)</literal> plus room for other applications</>
693
706
</row>
694
707
695
708
<row>
@@ -725,9 +738,8 @@ psql: could not connect to server: No such file or directory
725
738
(typically 48 bytes, on 64-bit platforms) for each copy of the server.
726
739
On most modern operating systems, this amount can easily be allocated.
727
740
However, if you are running many copies of the server, or if other
728
-
applications are also using System V shared memory, it may be necessary
729
-
to increase <varname>SHMMAX</>, the maximum size in bytes of a shared
730
-
memory segment, or <varname>SHMALL</>, the total amount of System V shared
741
+
applications are also using System V shared memory, it may be necessary to
742
+
increase <varname>SHMALL</>, which is the total amount of System V shared
731
743
memory system-wide. Note that <varname>SHMALL</> is measured in pages
732
744
rather than bytes on many systems.
733
745
</para>
@@ -742,6 +754,7 @@ psql: could not connect to server: No such file or directory
742
754
</para>
743
755
744
756
<para>
757
+
When using System V semaphores,
745
758
<productname>PostgreSQL</> uses one semaphore per allowed connection
746
759
(<xref linkend="guc-max-connections">), allowed autovacuum worker process
747
760
(<xref linkend="guc-autovacuum-max-workers">) and allowed background
@@ -779,15 +792,19 @@ psql: could not connect to server: No such file or directory
779
792
</para>
780
793
781
794
<para>
782
-
The <varname>SEMMSL</> parameter, which determines how many
783
-
semaphores can be in a set, must be at least 17 for
795
+
Various other settings related to <quote>semaphore undo</>, such as
796
+
<varname>SEMMNU</> and <varname>SEMUME</>, do not affect
784
797
<productname>PostgreSQL</>.
785
798
</para>
786
799
787
800
<para>
788
-
Various other settings related to <quote>semaphore undo</>, such as
789
-
<varname>SEMMNU</> and <varname>SEMUME</>, do not affect
790
-
<productname>PostgreSQL</>.
801
+
When using POSIX semaphores, the number of semaphores needed is the
802
+
same as for System V, that is one semaphore per allowed connection
803
+
(<xref linkend="guc-max-connections">), allowed autovacuum worker process
804
+
(<xref linkend="guc-autovacuum-max-workers">) and allowed background
805
+
process (<xref linkend="guc-max-worker-processes">).
806
+
On the platforms where this option is preferred, there is no specific
0 commit comments