Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id BE4661A88CDA for ; Wed, 8 Aug 2012 22:34:21 -0300 (ADT) Received: from mail-yw0-f46.google.com ([209.85.213.46]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SzHdi-0001Bh-0H for pgsql-admin@postgresql.org; Thu, 09 Aug 2012 01:34:20 +0000 Received: by yhmm54 with SMTP id m54so1496596yhm.19 for ; Wed, 08 Aug 2012 18:34:02 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=20120113; h=message-id:date:from:user-agent:mime-version:to:cc:subject :references:in-reply-to:content-type:content-transfer-encoding :x-gm-message-state; bh=a1zNWMlkDC0hnef7W9HSFyBiQgSTccfayNl26K4rif8=; b=kFiJexi2HVIKohgjjSRvHf+mTjNyMEzb8+jb2O1q2QkbjkqeFGY++lzBG48LOOYNBx GAdCjlBRu6dCPjlWw3RlojlIcjM6BzXnclFa+pdmVyDtoswi0Y45ERk9ubQHEBm4PE1s ct+WfxgSiPM7o3TFw622+xK62oIG+0W74ERRPJTgQpyj1AwmpC3QIU/y6eV9ijsIrNU/ w9AGe24Tj21baNGVQTVS/5OWAp4tNzQ1E3MNLuBfOnZqde7tqU+9nUReyIIK/hVAS2GU M2Rnr/EqLSplExvqsxU3N1V+qsUAjTg+qYVq4unuqdBAPsPdyOh4VoZ7C2YsT0YpWZ1g db6w== Received: by 10.50.182.226 with SMTP id eh2mr646974igc.69.1344476042238; Wed, 08 Aug 2012 18:34:02 -0700 (PDT) Received: from ayaki.localdomain (124-169-173-54.dyn.iinet.net.au. [124.169.173.54]) by mx.google.com with ESMTPS id nh1sm4032955igc.11.2012.08.08.18.33.58 (version=SSLv3 cipher=OTHER); Wed, 08 Aug 2012 18:34:01 -0700 (PDT) Message-ID: <50231383.90506@ringerc.id.au> Date: Thu, 09 Aug 2012 09:33:55 +0800 From: Craig Ringer User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:14.0) Gecko/20120717 Thunderbird/14.0 MIME-Version: 1.0 To: Kevin Grittner CC: Scott Marlowe , Radovan Jablonovsky , pgsql-admin Subject: Re: PostgreSQL oom_adj postmaster process to -17 References: <501925AD020000250004932E@gw.wicourts.gov> <5022849802000025000494BC@gw.wicourts.gov> In-Reply-To: <5022849802000025000494BC@gw.wicourts.gov> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Gm-Message-State: ALoCoQkDdxOiXdezBQocvT3U2jaYwz9Va7x3zugyc4W+Sx96FXQ3SoD3vj26J1uRYNHRYjWtFXgM X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201208/58 X-Sequence-Number: 39879 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 came up nobody was happy with wording of a comment so nothing got done. It's a real usability wart - causing real-world performance and reliability problems - that people unwittingly raise max_connections to absurd levels because they get no warnings, hints or guidance of any sort. -- Craig Ringer