On Sat, 11 Jul 2020 at 02:48, Vishwa Kalyankar
wrote:
> Below is the output of the query explain and analyze result.
You may find better help here if you follow the advice given in
https://wiki.postgresql.org/wiki/Slow_Query_Questions
David
On 7/10/20 7:48 AM, Vishwa Kalyankar wrote:
Hi,
Below is the output of the query explain and analyze result.
Note : port 5434 is postgresql12 and 5433 is postgresql10
Well that is not enlightening. What's happening inside the function is
not being shown. You might have to ask this o
Hi,
Below is the output of the query explain and analyze result.
Note : port 5434 is postgresql12 and 5433 is postgresql10
-bash-4.2$ psql -p 5434
psql (12.3)
Type "help" for help.
postgres=# \c IPDS_KSEB
You are now connected to database "IPDS_KSEB" as user "postgres".
IPDS_KSEB=# explai
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
Vishwa Kalyankar schrieb am 10.07.2020 um 08:50:
> 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.
Most of the slowdowns I have seen when u
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
Regards
