Обсуждение: Postgresql Performance Issue

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

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@openscg.com

On Fri, Aug 19, 2016 at 7:57 AM, <debasis.moharana@ipathsolutions.co.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@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs
>

On Fri, Aug 19, 2016 at 6:57 AM, <debasis.moharana@ipathsolutions.co.in> wrote:

> 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.

As David mentioned, this is not a bug report, so it doesn't belong
on this list.  I'm going to suggest that you follow the recommended
procedures for asking for help with slow queries.  Please read this
page and post to the pgsql-performance list:

https://wiki.postgresql.org/wiki/SlowQueryQuestions

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company