From: Justin Pryzby <pryzby@telsasoft.com>
To: yash mehta <yash215@gmail.com>
Cc: pgsql-performance@lists.postgresql.org
Subject: Re: select distinct runs slow on pg 10.6
Date: Mon, 9 Sep 2019 05:39:30 -0500
Message-ID: <20190909103930.GP7201@telsasoft.com> (raw)
In-Reply-To: <CAMgY1WkxX43j47Na4GMHDsOrJQL4M30jw-_Q3qwAWGh8b-MAhQ@mail.gmail.com>
References: <CAMgY1WkxX43j47Na4GMHDsOrJQL4M30jw-_Q3qwAWGh8b-MAhQ@mail.gmail.com>
On Mon, Sep 09, 2019 at 02:00:01PM +0530, yash mehta wrote:
> We have a query that takes 1min to execute in postgres 10.6 and the same
> executes in 4 sec in Oracle database. The query is doing 'select distinct'.
> If I add a 'group by' clause, performance in postgres improves
> significantly and fetches results in 2 sec (better than oracle). But
> unfortunately, we cannot modify the query. Could you please suggest a way
> to improve performance in Postgres without modifying the query.
Not sure it helps, but I remember this:
https://www.postgresql.org/message-id/CAKJS1f9q0j3BgMUsDbtf9%3DecfVLnqvkYB44MXj0gpVuamcN8Xw%40mail.g...
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: pryzby@telsasoft.com, yash215@gmail.com, pgsql-performance@lists.postgresql.org
Subject: Re: select distinct runs slow on pg 10.6
In-Reply-To: <20190909103930.GP7201@telsasoft.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox