Re: [pgadmin-support] Function not displaying PARALLEL SAFE on SQL tab

2017-01-18 Thread Dave Page
Thanks, logged here: https://redmine.postgresql.org/issues/2089 On Tue, Jan 17, 2017 at 6:13 PM, Shira Bezalel wrote: > I'm reviewing some PostGIS functions in pgAdmin 4. When I click on the SQL > tab, I notice that the "PARALLEL SAFE" qualifier doesn't show up. But when I > do an "\sf" on one of

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

2017-01-18 Thread Melvin Davidson
On Tue, Jan 17, 2017 at 3:12 PM, Ravi Tammineni < rtammin...@partner.aligntech.com> wrote: > Hi Adrain, > > We have deployed our databases in Heroku and we have followed the upgrade > option that they have provided to us. Here is the command. > > heroku pg:upgrade --app > > I am not sure whether

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

2017-01-18 Thread Ravi Tammineni
Hi Melvin, We have deployed our databases in Heroku and we have followed the upgrade option that they have provided to us. Here is the command. heroku pg:upgrade --app I am not sure whether they are doing the vacuum after the upgrade. I have disabled the parallel execution; still execution pl

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

2017-01-18 Thread Ravi Tammineni
Hi Adrain, We have deployed our databases in Heroku and we have followed the upgrade option that they have provided to us. Here is the command. heroku pg:upgrade --app I am not sure whether they are doing the vacuum after the upgrade or not. I have disabled the parallel execution; still execu

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

2017-01-18 Thread Adrian Klaver
On 01/17/2017 11:31 AM, Ravi Tammineni wrote: 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

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

2017-01-18 Thread Melvin Davidson
On Tue, Jan 17, 2017 at 2:31 PM, Ravi Tammineni < rtammin...@partner.aligntech.com> wrote: > 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

[pgadmin-support] Queries are taking way longer in 9.6 than 9.5

2017-01-18 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