Current Architecture
PrimaryHot Standby
Postgresql 9.3 Postgresql 9.3
DB Size 1.4 TB Database Size 1.4 TB
Want to upgrade both primary and hot Standby to 9.4 at same time. I m not able
to figure out how to upgrade Hot s
Thanks a lot. That’s what I am looking for
Thanks
Prabhjot Singh
From: Melvin Davidson [mailto:melvin6...@gmail.com]
Sent: Thursday, July 9, 2015 1:24 PM
To: Scott Marlowe
Cc: Sheena, Prabhjot; pgsql-general@postgresql.org
Subject: Re: [GENERAL] How to get total count of queries hitting DB per
: Sheena, Prabhjot
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] How to get total count of queries hitting DB per day or
per hour?
On Thu, Jul 9, 2015 at 12:04 PM, Sheena, Prabhjot
wrote:
> Guys
>
> Is there a way to get total count of queries hitting
> P
Guys
Is there a way to get total count of queries hitting Postgresql
DB(verison 9.3) per day or per hour ? I cannot turn on log_statement=all coz
that's too much logging for our log file to handle. Is there another way to do
that.
Thanks
Prabhjot
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
0
Thanks
Prabhjot Singh
-Original Message-
From: Jerry Sievers [mailto:gsiever...@comcast.net]
Sent: Thursday, June 18, 2015 12:47 PM
To: Sheena, Prabhjot
Cc: k...@rice.edu; Will Platnick; pgsql-performa...@postgresql.org;
pgsql-general@postgresql.org
Subject: Re: [PERFORM
pgbouncer (init script, etc..)) even though we are
not reaching 4096 max value
Regards
Prabhjot Singh
-Original Message-
From: k...@rice.edu [mailto:k...@rice.edu]
Sent: Thursday, June 18, 2015 11:10 AM
To: Sheena, Prabhjot
Cc: pgsql-performa...@postgresql.org; pgsql-general@postgresql.org
: Sheena, Prabhjot
Cc: pgsql-performa...@postgresql.org; pgsql-general@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
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
98101
206.301.4937 o
206.301.5701 f
From: Sheena, Prabhjot
Sent: Friday, June 12, 2015 10:57 AM
To: 'pgsql-general@postgresql.org'; 'pgsql-performa...@postgresql.org'
Subject: pg bouncer issue what does sv_used column means
Guys we see spike in pg bouncer during the peak hours
Guys we see spike in pg bouncer during the peak hours and that was slowing down
the application. We did bump up the connection limit and it is helpful but now
we again notice little spike in connection. And one thing that I notice that
is different is jump in sv_used value when I run command sh
tor=0.02
Thanks
From: Igor Neyman [mailto:iney...@perceptron.com]
Sent: Friday, June 5, 2015 11:06 AM
To: Sheena, Prabhjot; pgsql-general@postgresql.org;
pgsql-performa...@postgresql.org
Subject: RE: Query running slow for only one specific id. (Postgres 9.3) version
From:
pgsql-performan
Postgresql 9.3 Version
Guys
Here is the issue that I'm facing for couple of weeks now. I have
table (size 7GB)
If I run this query with this specific registration id it is using the wrong
execution plan and takes more than a minute to complete. Total number of rows
for this registr
13 matches
Mail list logo
