Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Z5eGj-0007Wj-Mr for pgsql-general@arkaria.postgresql.org; Thu, 18 Jun 2015 18:10:29 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1Z5eGj-0000dn-0A for pgsql-general@arkaria.postgresql.org; Thu, 18 Jun 2015 18:10:29 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1Z5eGh-0000dd-Ro; Thu, 18 Jun 2015 18:10:28 +0000 Received: from proofpoint2.mail.rice.edu ([128.42.201.101] helo=pp2.rice.edu) by makus.postgresql.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84) (envelope-from ) id 1Z5eGf-0008GG-DP; Thu, 18 Jun 2015 18:10:26 +0000 Received: from pps.filterd (pp2.rice.edu [127.0.0.1]) by pp2.rice.edu (8.14.5/8.14.5) with SMTP id t5II6gSw016059; Thu, 18 Jun 2015 13:10:23 -0500 Received: from mh2.mail.rice.edu (mh2.mail.rice.edu [128.42.201.21]) by pp2.rice.edu with ESMTP id 1v3gc2gg7x-1; Thu, 18 Jun 2015 13:10:23 -0500 X-Virus-Scanned: by amavis-2.7.0 at mh2.mail.rice.edu, auth channel 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 mh2.mail.rice.edu (Postfix) with ESMTP id 4A8B3500129; Thu, 18 Jun 2015 13:10:23 -0500 (CDT) Received: by aart.rice.edu (Postfix, from userid 18612) id 423D8100876; Thu, 18 Jun 2015 13:10:23 -0500 (CDT) Date: Thu, 18 Jun 2015 13:10:23 -0500 From: "ktm@rice.edu" To: "Sheena, Prabhjot" Cc: "pgsql-performance@postgresql.org" , "pgsql-general@postgresql.org" Subject: Re: [PERFORM] PGBOUNCER ISSUE PLEASE HELP(Slowing down the site) Message-ID: <20150618181023.GU31129@aart.rice.edu> References: <13E39D789E19FF4E9A87F6D456F3F9820123C607@SEAMBX02.sea.corp.int.untd.com> <20150618171623.GT31129@aart.rice.edu> <13E39D789E19FF4E9A87F6D456F3F9820123C645@SEAMBX02.sea.corp.int.untd.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <13E39D789E19FF4E9A87F6D456F3F9820123C645@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 kscore.is_bulkscore=6.5669691906578e-14 kscore.compositescore=0 circleOfTrustscore=0 compositescore=0.999147469938476 suspectscore=0 recipient_domain_to_sender_totalscore=0 phishscore=0 bulkscore=0 kscore.is_spamscore=0 rbsscore=0.999147469938476 recipient_to_sender_totalscore=0 recipient_domain_to_sender_domain_totalscore=0 spamscore=0 recipient_to_sender_domain_totalscore=0 urlsuspectscore=0.999147469938476 adultscore=0 classifier=spam adjust=0 reason=mlx scancount=1 engine=7.0.1-1402240000 definitions=main-1506180301 X-Pg-Spam-Score: -2.9 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-general Precedence: bulk Sender: pgsql-general-owner@postgresql.org On Thu, Jun 18, 2015 at 05:41:01PM +0000, Sheena, Prabhjot wrote: > Here is the output of OS limits > > postgres@symds-pg:~ $ ulimit -a > > core file size (blocks, -c) 0 > data seg size (kbytes, -d) unlimited > scheduling priority (-e) 0 > file size (blocks, -f) unlimited > pending signals (-i) 790527 > max locked memory (kbytes, -l) 32 > max memory size (kbytes, -m) unlimited > open files (-n) 4096 > pipe size (512 bytes, -p) 8 > POSIX message queues (bytes, -q) 819200 > real-time priority (-r) 0 > stack size (kbytes, -s) 10240 > cpu time (seconds, -t) unlimited > max user processes (-u) 16384 > virtual memory (kbytes, -v) unlimited > file locks (-x) unlimited > > > Thanks > Prabhjot > I would bump your open files as was suggested in your pgbouncer start script. Regards, Ken -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general