Re: [HACKERS] Wiki link for max_connections? (Fwd: Re: [ADMIN] PostgreSQL oom_adj postmaster process to -17)

2012-09-04 Thread Robert Haas
On Tue, Sep 4, 2012 at 11:15 AM, Kevin Grittner wrote: > It is something which has to be considered, and I don't think it's > theoretical at all. Here's how we deal with it. We don't use a > plain FIFO queue for our transaction requests, but a prioritized > FIFO with 10 levels of priority (0 to

Re: [HACKERS] Wiki link for max_connections? (Fwd: Re: [ADMIN] PostgreSQL oom_adj postmaster process to -17)

2012-09-04 Thread Kevin Grittner
Robert Haas wrote: > Kevin Grittner wrote: >>> Also, I am a bit doubtful about the advice on sizing the >>> connection pool as applied to small servers: >>> surely it's not sane to recommend that a single-processor system >>> with one disk should have max_connections = 3. At least, *I* >>> don

Re: [HACKERS] Wiki link for max_connections? (Fwd: Re: [ADMIN] PostgreSQL oom_adj postmaster process to -17)

2012-08-30 Thread Robert Haas
On Thu, Aug 9, 2012 at 1:11 PM, Kevin Grittner wrote: > I didn't figure it was; my emphasis was because this has been raised > before and nothing happened for want of a consensus on what > particular wording should be used, so users were left with no > guidance. I don't want this to continue to b

Re: [HACKERS] Wiki link for max_connections? (Fwd: Re: [ADMIN] PostgreSQL oom_adj postmaster process to -17)

2012-08-09 Thread Kevin Grittner
Robert Haas wrote: > Kevin Grittner wrote: >> we *really* need to actually get *something* into the docs on >> this, > Sure, I'm not opposed to documenting it. Putting it in the actual > documentation is not a demotion relative to putting a link to it > in the documentation! I didn't figur

Re: [HACKERS] Wiki link for max_connections? (Fwd: Re: [ADMIN] PostgreSQL oom_adj postmaster process to -17)

2012-08-09 Thread Robert Haas
On Thu, Aug 9, 2012 at 11:27 AM, Kevin Grittner wrote: > Robert Haas wrote: >> Kevin Grittner 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_connecti

Re: [HACKERS] Wiki link for max_connections? (Fwd: Re: [ADMIN] PostgreSQL oom_adj postmaster process to -17)

2012-08-09 Thread Kevin Grittner
Robert Haas wrote: > Kevin Grittner 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

Re: [HACKERS] Wiki link for max_connections? (Fwd: Re: [ADMIN] PostgreSQL oom_adj postmaster process to -17)

2012-08-09 Thread Robert Haas
On Thu, Aug 9, 2012 at 10:22 AM, Kevin Grittner 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 y

[HACKERS] Wiki link for max_connections? (Fwd: Re: [ADMIN] PostgreSQL oom_adj postmaster process to -17)

2012-08-09 Thread Kevin Grittner
[Forwarding to the -hackers list. Please respond there.] Craig Ringer wrote: > On 08/09/2012 04:24 AM, Kevin Grittner wrote: >> http://wiki.postgresql.org/wiki/Number_Of_Database_Connections >> > Can we please please PLEASE link to that as a comment above > max_connections? > > Last time this c