From: Jerry Sievers <gsievers19@comcast.net>
To: "Sheena\, Prabhjot" <Prabhjot.Singh@classmates.com>
Cc: "ktm\@rice.edu" <ktm@rice.edu>, Will Platnick <wplatnick@gmail.com>,
 "pgsql-performance\@postgresql.org" <pgsql-performance@postgresql.org>,
 "pgsql-general\@postgresql.org" <pgsql-general@postgresql.org>
Subject: Re: [PERFORM] PGBOUNCER ISSUE PLEASE HELP(Slowing down the site)
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>
Date: Thu, 18 Jun 2015 14:46:36 -0500
In-Reply-To: 
 <13E39D789E19FF4E9A87F6D456F3F9820123D71A@SEAMBX02.sea.corp.int.untd.com>
 (Prabhjot Sheena's message of "Thu, 18 Jun 2015 19:19:13 +0000")
Message-ID: <868ubgajfn.fsf@jerry.enova.com>
User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/23.4 (gnu/linux)
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Precedence: bulk
Sender: pgsql-general-owner@postgresql.org

"Sheena, Prabhjot" <Prabhjot.Singh@classmates.com> writes:

> 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

If I can assume you're running on linux, best you get limits readout
from...

/proc/$PID-of-bouncer-process/limits

Best not to trust that run time env of interactive shell is same as
where bouncer launched from.

FWIW


> Regards
> Prabhjot Singh
>
>
>
> -----Original Message-----
> From: ktm@rice.edu [mailto:ktm@rice.edu] 
> Sent: Thursday, June 18, 2015 11:10 AM
> To: Sheena, Prabhjot
> Cc: pgsql-performance@postgresql.org; pgsql-general@postgresql.org
> Subject: Re: [PERFORM] PGBOUNCER ISSUE PLEASE HELP(Slowing down the site)
>
> 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

-- 
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres.consulting@comcast.net
p: 312.241.7800


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general