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

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: Postgresql-12 taking more time to execute the query
Дата
Msg-id 039abe24-87b3-1ac7-8391-c61c8f2917de@aklaver.com
обсуждение исходный текст
Ответ на Postgresql-12 taking more time to execute the query  (Vishwa Kalyankar <vishwakalyankar8@gmail.com>)
Ответы Re: Postgresql-12 taking more time to execute the query  (Vishwa Kalyankar <vishwakalyankar8@gmail.com>)
Список 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.klaver@aklaver.com

В списке pgsql-general по дате отправления:

Предыдущее
От: Brajendra Pratap Singh
Дата:
Сообщение: Re: Wal_keep_segment value too high
Следующее
От: Deepika S Gowda
Дата:
Сообщение: Issue with timestamp without time zone datatype with default value as now()/localtimestamp