pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: ktm@rice.edu <ktm@rice.edu>
To: Sheena, Prabhjot <Prabhjot.Singh@classmates.com>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Cc: pgsql-general@postgresql.org <pgsql-general@postgresql.org>
Subject: Re: [PERFORM] PGBOUNCER ISSUE PLEASE HELP(Slowing down the site)
Date: Thu, 18 Jun 2015 13:10:23 -0500
Message-ID: <20150618181023.GU31129@aart.rice.edu> (raw)
In-Reply-To: <13E39D789E19FF4E9A87F6D456F3F9820123C645@SEAMBX02.sea.corp.int.untd.com>
References: <13E39D789E19FF4E9A87F6D456F3F9820123C607@SEAMBX02.sea.corp.int.untd.com>
	<20150618171623.GT31129@aart.rice.edu>
	<13E39D789E19FF4E9A87F6D456F3F9820123C645@SEAMBX02.sea.corp.int.untd.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-general>

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



view thread (10+ messages)  latest in thread

Message-ID: <20150618181023.GU31129@aart.rice.edu>
Permalink:  ../20150618181023.GU31129@aart.rice.edu/
Also on:    postgresql.org/message-id/20150618181023.GU31129@aart.rice.edu

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: ktm@rice.edu, Prabhjot.Singh@classmates.com, pgsql-general@postgresql.org
  Subject: Re: [PERFORM] PGBOUNCER ISSUE PLEASE HELP(Slowing down the site)
  In-Reply-To: <20150618181023.GU31129@aart.rice.edu>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox