Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxx





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux