[prev in list] [next in list] [prev in thread] [next in thread] 

List:       pgsql-bugs
Subject:    Re: [BUGS] Postgresql Performance Issue
From:       Kevin Grittner <kgrittn () gmail ! com>
Date:       2016-08-19 15:27:48
Message-ID: CACjxUsPFYzLExC9=hdxd0K3dvKmqhOCXq=3_1G6nWu=Ub9h=Mg () mail ! gmail ! com
[Download RAW message or body]

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


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
[prev in list] [next in list] [prev in thread] [next in thread]