Re: [GENERAL] Queries are taking way longer in 9.6 than 9.5

2017-01-18 Thread Ravi Tammineni
hanks ravi -Original Message- From: Chris Mair [mailto:ch...@1006.org] Sent: Tuesday, January 17, 2017 4:22 PM To: Tomas Vondra ; Ravi Tammineni Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Queries are taking way longer in 9.6 than 9.5 On 17/01/17 23:21, Tomas Vondra wrote: &

Re: [GENERAL] Queries are taking way longer in 9.6 than 9.5

2017-01-17 Thread Ravi Tammineni
...@1006.org] Sent: Tuesday, January 17, 2017 12:39 PM To: Ravi Tammineni Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Queries are taking way longer in 9.6 than 9.5 Hi. > explain analyze > > SELECT count(*) > > [...] >

Re: [GENERAL] Queries are taking way longer in 9.6 than 9.5

2017-01-17 Thread Ravi Tammineni
-Original Message- From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] Sent: Tuesday, January 17, 2017 11:42 AM To: Ravi Tammineni ; pgsql-ad...@postgresql.org; pgsql-general@postgresql.org; pgadmin-supp...@postgresql.org Subject: Re: [GENERAL] Queries are taking way longer in 9.

Re: [GENERAL] Queries are taking way longer in 9.6 than 9.5

2017-01-17 Thread Ravi Tammineni
From: Melvin Davidson [mailto:melvin6...@gmail.com] Sent: Tuesday, January 17, 2017 11:36 AM To: Ravi Tammineni Cc: pgsql-ad...@postgresql.org; pgsql-general@postgresql.org; pgadmin-supp...@postgresql.org Subject: Re: [GENERAL] Queries are taking way longer in 9.6 than 9.5 On Tue, Jan 17, 2017 at

[GENERAL] Queries are taking way longer in 9.6 than 9.5

2017-01-17 Thread Ravi Tammineni
Hi, We have recently upgraded to 9.6 and few queries are performing very poorly. Query execution time has increased more 4 or 5 times in 9.6. Qeruy execution plan is also completely changed. I am not sure whether its because of Parallel feature or any bug in 9.6. There are few similar kind of q

Re: [GENERAL] Postgresql BDR Replication Setup Issue

2015-06-09 Thread Ravi Tammineni
: Monday, June 08, 2015 4:17 PM To: Ravi Tammineni; tomas.von...@2ndquadrant.com; pgsql-general@postgresql.org Subject: Re: [GENERAL] Postgresql BDR Replication Setup Issue Hi On 15/06/09 2:31, Ravi Tammineni wrote: > We are setting up 2-node Postgresql BDR replication at our place and I > am g

[GENERAL] Postgresql BDR Replication Setup Issue

2015-06-08 Thread Ravi Tammineni
Hi, We are setting up 2-node Postgresql BDR replication at our place and I am getting the following error after bdr_init_copy command. FYI, We have a production Postgres database and we are setting up the Master-Master BDR replication for the production database. Postgres Version Postgres