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
] On Behalf Of Sheena, Prabhjot
Sent: Friday, June 05, 2015 1:55 PM
To: pgsql-gene...@postgresql.orgmailto:pgsql-gene...@postgresql.org;
pgsql-performance@postgresql.orgmailto:pgsql-performance@postgresql.org
Subject: [PERFORM] Query running slow for only one specific id. (Postgres 9.3)
version
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
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:09:10PM +, Sheena, Prabhjot wrote:
Guys
I have an issue going on with PGBOUNCER which is slowing down
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-performance@postgresql.org; pgsql-gene...@postgresql.org
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-performance@postgresql.org;
pgsql-gene...@postgresql.org
Subject: Re: [PERFORM
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
98101
206.301.4937 o
206.301.5701 f
From: Sheena, Prabhjot
Sent: Friday, June 12, 2015 10:57 AM
To: 'pgsql-gene...@postgresql.org'; 'pgsql-performance@postgresql.org'
Subject: pg bouncer issue what does sv_used column means
Guys we see spike in pg bouncer during the peak hours and that was slowing
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
Guys I m trying to upgrade postgresql 9.3 -> 9.4
OS VERSION : CentOS release 6.3 (Final) (2.6.32-279.el6.x86_64.x86_64)
When I run the upgrade script /usr/pgsql-9.4/bin/pg_upgrade
It gives me this error in the log file.
pg_restore: creating VIEW tables
pg_restore: [archiver (db)] Error
10 matches
Mail list logo