Re: Postgresql-12 taking more time to execute the query

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Vishwa Kalyankar <vishwakalyankar8(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Postgresql-12 taking more time to execute the query
Date: 2020-07-10 13:53:53
Message-ID: 039abe24-87b3-1ac7-8391-c61c8f2917de@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Deepika S Gowda 2020-07-10 14:03:19 Issue with timestamp without time zone datatype with default value as now()/localtimestamp
Previous Message Brajendra Pratap Singh 2020-07-10 13:02:01 Re: Wal_keep_segment value too high