Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgresql-12 taking more time to execute the query - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Postgresql-12 taking more time to execute the query
Date
Msg-id 039abe24-87b3-1ac7-8391-c61c8f2917de@aklaver.com
Whole thread Raw
In response to Postgresql-12 taking more time to execute the query  (Vishwa Kalyankar <vishwakalyankar8@gmail.com>)
Responses Re: Postgresql-12 taking more time to execute the query
List pgsql-general
Tree view 
On 7/9/20 11:50 PM, Vishwa Kalyankar wrote:
> Hi Team,
> 
>     I Need help or any suggestion on below mentioned issue.
> 
> Previously we are running postgresql-10with postgis 2.5.3 and now we are 
> updated to postgresql-12 and postgis-3.0.1, and in postgresql-10 one 
> query is taking 20 sec and same query is taking upto 80 sec. thanks in 
> advance

The actual query and EXPLAIN ANALYZE for both runs of the query would be 
useful.

> 
> Regards,
> 
> Vishwa S Kalyankar
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com

pgsql-general by date:

Previous
From: Brajendra Pratap Singh
Date:
Subject: Re: Wal_keep_segment value too high
Next
From: Deepika S Gowda
Date:
Subject: Issue with timestamp without time zone datatype with default value as now()/localtimestamp