| From: | "ktm(at)rice(dot)edu" <ktm(at)rice(dot)edu> |
|---|---|
| To: | "Sheena, Prabhjot" <Prabhjot(dot)Singh(at)classmates(dot)com> |
| Cc: | "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 18:10:23 |
| Message-ID: | 20150618181023.GU31129@aart.rice.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-performance |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sheena, Prabhjot | 2015-06-18 19:19:13 | Re: PGBOUNCER ISSUE PLEASE HELP(Slowing down the site) |
| Previous Message | Sheena, Prabhjot | 2015-06-18 17:41:01 | Re: PGBOUNCER ISSUE PLEASE HELP(Slowing down the site) |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Igor Neyman | 2015-06-18 18:16:07 | Re: How to calculate statistics for one column |
| Previous Message | Irineu Ruiz | 2015-06-18 17:52:32 | How to calculate statistics for one column |