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 robertmh...@gmail.com wrote: Kevin Grittner kevin.gritt...@wicourts.gov 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

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 kevin.gritt...@wicourts.gov 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

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 kevin.gritt...@wicourts.gov 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

[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 ring...@ringerc.id.au 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?

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 kevin.gritt...@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

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 robertmh...@gmail.com wrote: Kevin Grittner kevin.gritt...@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

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 kevin.gritt...@wicourts.gov wrote: Robert Haas robertmh...@gmail.com wrote: Kevin Grittner kevin.gritt...@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.

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 robertmh...@gmail.com wrote: Kevin Grittner kevin.gritt...@wicourts.gov 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