Re: [PERFORM] pgsql-performance issue

2016-08-21 Thread debasis . moharana
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

Re: [PERFORM] pgsql-performance issue

2016-08-20 Thread debasis . moharana
[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

Re: [PERFORM] pgsql-performance issue

2016-08-20 Thread debasis . moharana
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]

Re: [PERFORM] pgsql-performance issue

2016-08-20 Thread debasis . moharana
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 -

[PERFORM] pgsql-performance issue

2016-08-20 Thread debasis . moharana
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

[PERFORM] pgsql-performance issue

2016-08-20 Thread debasis . moharana
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