-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
> Guys can anyone please explain or point me to a link where i
> can understand this output for pgbouncer. What does each column of this table
> mean?
>
> pgbouncer=# show mem;
(Please do not post to more than one mailing list at a time). It
Guys can anyone please explain or point me to a link where i can understand
this output for pgbouncer. What does each column of this table mean?
pgbouncer=# show mem;
name | size | used | free | memtotal
--+--+--+--+--
user_cache | 184 | 12 | 77
2015 11:10 AM
> To: Sheena, Prabhjot
> Cc: pgsql-performance@postgresql.org; pgsql-gene...@postgresql.org
> Subject: Re: [PERFORM] PGBOUNCER ISSUE PLEASE HELP(Slowing down the
> site)
>
> On Thu, Jun 18, 2015 at 05:41:01PM +, Sheena, Prabhjot wrote:
>> Here is the output of OS limi
On Thu, Jun 18, 2015 at 07:19:13PM +, Sheena, Prabhjot wrote:
> 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 5000
: Re: [PERFORM] PGBOUNCER ISSUE PLEASE HELP(Slowing down the site)
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 5 ( Add
ormance@postgresql.org; pgsql-gene...@postgresql.org
> Subject: Re: [PERFORM] PGBOUNCER ISSUE PLEASE HELP(Slowing down the site)
>
> On Thu, Jun 18, 2015 at 05:41:01PM +, Sheena, Prabhjot wrote:
>> Here is the output of OS limits
>>
>> postgres@symds-pg:~ $ ulimit -a
&g
Subject: Re: [PERFORM] PGBOUNCER ISSUE PLEASE HELP(Slowing down the site)
On Thu, Jun 18, 2015 at 05:41:01PM +, Sheena, Prabhjot wrote:
> Here is the output of OS limits
>
> postgres@symds-pg:~ $ ulimit -a
>
> core file size (blocks, -c) 0
> data seg size
On Thu, Jun 18, 2015 at 05:41:01PM +, 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 (b
: Sheena, Prabhjot
Cc: pgsql-performance@postgresql.org; pgsql-gene...@postgresql.org
Subject: Re: [PERFORM] PGBOUNCER ISSUE PLEASE HELP(Slowing down the site)
On Thu, Jun 18, 2015 at 05:09:10PM +, Sheena, Prabhjot wrote:
> Guys
> I have an issue going on with PGBOUNCER which is slowin
My guess is you are hitting an open file ulimit. Add ulimit -n 5 to
the start of whatever you use to start pgbouncer (init script, etc..)
On Thu, Jun 18, 2015 at 1:10 PM Sheena, Prabhjot <
prabhjot.si...@classmates.com> wrote:
> Guys
>
> I have an issue going on with PGBOUNCER whic
On Thu, Jun 18, 2015 at 05:09:10PM +, Sheena, Prabhjot wrote:
> Guys
> I have an issue going on with PGBOUNCER which is slowing down the
> site
>
> PGBOUNCER VERSION: pgbouncer-1.5.4-2.el6 (Hosted on separate machine) (16
> cpu) 98GB RAM
> DATABASE VERION: postgresql 9.3
>
Guys
I have an issue going on with PGBOUNCER which is slowing down the site
PGBOUNCER VERSION: pgbouncer-1.5.4-2.el6 (Hosted on separate machine) (16 cpu)
98GB RAM
DATABASE VERION: postgresql 9.3
When the total client connections to pgbouncer are close to 1000, site
applicatio
12 matches
Mail list logo
