query
https://www.postgresql.org/docs/current/static/sql-explain.html
[2] [3]
[3]
[3]
https://explain.depesz.com/ [3] [4] [4] [4]
p.s. Did you do VACUUM and ANALYZE on database?
Regards
Pavel
Regards,
Debasis Moharana
.NET Software Developer
--
Sent via pgsql-performance mailing list
[3]
[3]
[3]
https://explain.depesz.com/ [4] [4] [4]
p.s. Did you do VACUUM and ANALYZE on database?
Regards
Pavel
Regards,
Debasis Moharana
.NET Software Developer
--
Sent via pgsql-performance mailing list
(pgsql-performance@postgresql.org)
To make changes to your subscription
YZE on database?
Regards
Pavel
Regards,
Debasis Moharana
.NET Software Developer
--
Sent via pgsql-performance mailing list
(pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance [1] [2]
Links:
--
[1]
ve the perfermance in postgresql.
hi
please, send execution plan of slow query
https://www.postgresql.org/docs/current/static/sql-explain.html [3]
https://explain.depesz.com/ [4]
p.s. Did you do VACUUM and ANALYZE on database?
Regards
Pavel
Regards,
Debasis Moharana
.NET Software Developer
-
query to fetch large
amount of record of 29000 in postgresql but it takes 10.3 seconds but
the same query takes 2 seconds for execution in MSSQL.
So my query is how to improve the perfermance in postgresql.
Regards,
Debasis Moharana
.NET Software Developer
--
Sent via pgsql-performance
After setting in postgresql.conf. I run the select query to fetch large
amount of record of 29000 in postgresql but it takes 10.3 seconds but
the same query takes 2 seconds for execution in MSSQL.
So my query is how to improve the perfermance in postgresql.
Regards,
Debasis Moharana
.NET So