From: Kevin Grittner <Kevin.Grittner@wicourts.gov>
To: Robert Haas <robertmhaas@gmail.com>
Cc: pgsql-hackers@postgresql.org
Subject: Re: Wiki link for max_connections? (Fwd: Re: [ADMIN] PostgreSQL oom_adj postmaster process to -17)
Date: Thu, 09 Aug 2012 10:27:27 -0500
Message-ID: <5023908F02000025000494E6@gw.wicourts.gov> (raw)
In-Reply-To: <CA+TgmoZhgdfXHrnstYC54eOt-tCWfTHasUdkA9MPDfLrdA8A=g@mail.gmail.com>
References: <5023815E02000025000494E2@gw.wicourts.gov>
<CA+TgmoZhgdfXHrnstYC54eOt-tCWfTHasUdkA9MPDfLrdA8A=g@mail.gmail.com>
Robert Haas <robertmhaas@gmail.com> wrote:
> Kevin Grittner <Kevin.Grittner@wicourts.gov> wrote:
>> I see that we currently have five links to wiki.postgresql.org in
>> release notes and four more in the rest of the docs. Are people
>> OK with adding this link to the docs on max_connections? (Feel
>> free to improve it before answering if you have qualms about the
>> specifics on that page.)
>
> I'm generally not in favor of linking to the wiki unless there's
> some reason that it wouldn't be appropriate to include the
> material in the documentation in some form. I don't see that
> that's the case here.
All right, but we *really* need to actually get *something* into the
docs on this, preferably back-patched. In the -admin thread which
prompted Craig to plead for a link to the Wiki page, the OP thought
it was reasonable to worry about how to configure the oom killer to
deal with the situation that his 600 connections used all 32GB of
RAM *plus* the 32GB of swap space he has configured. Imagine what
performance must be like by the time it gets to *that* point!
The OP clearly has read the docs, because he was attempting to take
advice from the section on Linux Memory Overcommit. But as far as I
have seen, there is nothing in the docs to suggest connection
pooling. It is far better to avoid the oom killer by connection
pooling than to tweak the oom killer configuration, yet you wouldn't
have a clue about that from the docs.
I actually think that the issue merits space in the docs roughly
matchnig the Wiki page. Perhaps we could find a place in the Server
Setup and Operation chapter to more-or-less include the current Wiki
page contents, and reference *that* from the max_connections docs?
-Kevin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: Kevin.Grittner@wicourts.gov, robertmhaas@gmail.com, pgsql-hackers@postgresql.org
Subject: Re: Wiki link for max_connections? (Fwd: Re: [ADMIN] PostgreSQL oom_adj postmaster process to -17)
In-Reply-To: <5023908F02000025000494E6@gw.wicourts.gov>
References: <5023815E02000025000494E2@gw.wicourts.gov> <CA+TgmoZhgdfXHrnstYC54eOt-tCWfTHasUdkA9MPDfLrdA8A=g@mail.gmail.com> <5023908F02000025000494E6@gw.wicourts.gov>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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