Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Z5g0y-0004cF-2o for pgsql-performance@arkaria.postgresql.org; Thu, 18 Jun 2015 20:02:20 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1Z5g0w-0003gP-Gt for pgsql-performance@arkaria.postgresql.org; Thu, 18 Jun 2015 20:02:18 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1Z5g0r-0003X9-AV; Thu, 18 Jun 2015 20:02:13 +0000 Received: from proofpoint1.mail.rice.edu ([128.42.201.100] helo=pp1.rice.edu) by magus.postgresql.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84) (envelope-from ) id 1Z5g0m-0003N7-Fu; Thu, 18 Jun 2015 20:02:11 +0000 Received: from pps.filterd (pp1.rice.edu [127.0.0.1]) by pp1.rice.edu (8.14.5/8.14.5) with SMTP id t5IK1kWB016107; Thu, 18 Jun 2015 15:02:04 -0500 Received: from mh3.mail.rice.edu (mh3.mail.rice.edu [128.42.199.10]) by pp1.rice.edu with ESMTP id 1v34cph2wq-1; Thu, 18 Jun 2015 15:02:03 -0500 X-Virus-Scanned: by amavis-2.7.0 at mh3.mail.rice.edu, auth channel X-SMTP-Auth: no X-SMTP-Auth: no X-SMTP-Auth: no X-SMTP-Auth: no Received: from aart.rice.edu (aart.rice.edu [168.7.56.48]) by mh3.mail.rice.edu (Postfix) with ESMTP id BA5BB403E5; Thu, 18 Jun 2015 15:02:03 -0500 (CDT) Received: by aart.rice.edu (Postfix, from userid 18612) id B183E100828; Thu, 18 Jun 2015 15:02:03 -0500 (CDT) Date: Thu, 18 Jun 2015 15:02:03 -0500 From: "ktm@rice.edu" To: "Sheena, Prabhjot" Cc: Will Platnick , "pgsql-performance@postgresql.org" , "pgsql-general@postgresql.org" Subject: Re: PGBOUNCER ISSUE PLEASE HELP(Slowing down the site) Message-ID: <20150618200203.GV31129@aart.rice.edu> References: <13E39D789E19FF4E9A87F6D456F3F9820123C607@SEAMBX02.sea.corp.int.untd.com> <20150618171623.GT31129@aart.rice.edu> <13E39D789E19FF4E9A87F6D456F3F9820123C645@SEAMBX02.sea.corp.int.untd.com> <20150618181023.GU31129@aart.rice.edu> <13E39D789E19FF4E9A87F6D456F3F9820123D71A@SEAMBX02.sea.corp.int.untd.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <13E39D789E19FF4E9A87F6D456F3F9820123D71A@SEAMBX02.sea.corp.int.untd.com> User-Agent: Mutt/1.5.20 (2009-12-10) X-Proofpoint-Spam-Details: rule=notspam policy=default score=0 spamscore=0 suspectscore=0 phishscore=0 adultscore=0 bulkscore=0 classifier=spam adjust=0 reason=mlx scancount=1 engine=7.0.1-1402240000 definitions=main-1506180329 X-Pg-Spam-Score: -4.5 (----) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org On Thu, Jun 18, 2015 at 07:19:13PM +0000, Sheena, Prabhjot wrote: > Hi Ken/ Will > > I have checked the ulimit value and we are nowhere hitting the max 4096 that we have currently set. Is there any other explanation why we should be thinking of bumping it to like ulimit -n 50000 ( Add ulimit -n 50000 to the start of whatever you use to start pgbouncer (init script, etc..)) even though we are not reaching 4096 max value > > Regards > Prabhjot Singh > Hi, Try attaching to the pgbouncer with strace and see if you are getting any particular errors. Do you have a /etc/security/limits.d directory? And if so, what is in it? We found a nice default ulimit of 1024 for all non-root users. :( Regards, Ken -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance