From: | Jerry Sievers <gsievers19(at)comcast(dot)net> |
---|---|
To: | "Sheena\, Prabhjot" <Prabhjot(dot)Singh(at)classmates(dot)com> |
Cc: | "ktm\(at)rice(dot)edu" <ktm(at)rice(dot)edu>, Will Platnick <wplatnick(at)gmail(dot)com>, "pgsql-performance\(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>, "pgsql-general\(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: [PERFORM] PGBOUNCER ISSUE PLEASE HELP(Slowing down the site) |
Date: | 2015-06-18 19:46:36 |
Message-ID: | 868ubgajfn.fsf@jerry.enova.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-performance |
"Sheena, Prabhjot" <Prabhjot(dot)Singh(at)classmates(dot)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(at)rice(dot)edu [mailto:ktm(at)rice(dot)edu]
> Sent: Thursday, June 18, 2015 11:10 AM
> To: Sheena, Prabhjot
> Cc: pgsql-performance(at)postgresql(dot)org; pgsql-general(at)postgresql(dot)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(at)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(dot)consulting(at)comcast(dot)net
p: 312.241.7800
From | Date | Subject | |
---|---|---|---|
Next Message | Igor Neyman | 2015-06-18 19:59:25 | Re: PGBOUNCER ISSUE PLEASE HELP(Slowing down the site) |
Previous Message | Sheena, Prabhjot | 2015-06-18 19:19:13 | Re: PGBOUNCER ISSUE PLEASE HELP(Slowing down the site) |
From | Date | Subject | |
---|---|---|---|
Next Message | Igor Neyman | 2015-06-18 19:52:51 | Re: How to calculate statistics for one column |
Previous Message | Duane Murphy | 2015-06-18 19:38:55 | Techniques to Avoid Temp Files |