Re: Postgresql Performance Issue

Hello -

This is not a PostgreSQL bug. Please try your question on the General list (
https://www.postgresql.org/list/pgsql-general/) or, because you are using
the bigsql distribution, you could try their feedback forum.

To get useful help, it will be critical for you to provide information such
as your schema, the query you tried to run, hardware specs, etc. How to
tune a query and Postgres system depends on all of these.

--
David Rader
davidr(at)openscg(dot)com

On Fri, Aug 19, 2016 at 7:57 AM, <debasis(dot)moharana(at)ipathsolutions(dot)co(dot)in>
wrote:

> 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
>
>
> --
> Sent via pgsql-bugs mailing list (pgsql-bugs(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs
>