Dear Sir/Mam,
i am Debasis I want to migrate a database from MSSQL to
Postgresql.9.5.I have install the exe
file(PostgreSQL-9.5.4-2-win64-bigsql) i have migrate the tables from
MSSQL database to postgresql database with data.But When i execute a
simple query to fetch 35000 of records it takes 2 seconds in MSSQL but
when i execute the same query in Postgresql it takes 10.3 seconds to
fetch the record.
I have R & D on it and find solution to setting postgresql.conf file
but still having same problem.
Can you please guide me how to improve the performance of fetching the
record?
Regards,
Debasis Moharana
.NET Developer