Postgres Pro
Downloads
Home   >   mailing lists

Re: Removing useless DISTINCT clauses - Mailing list pgsql-hackers

From David Rowley
Subject Re: Removing useless DISTINCT clauses
Date
Msg-id CAKJS1f9GxhaP_6pa=DsNEbXw1dJVPQ7scZ9qhg7+P2w4yXSpHg@mail.gmail.com
Whole thread Raw
In response to Re: Removing useless DISTINCT clauses  ("Finnerty, Jim" <jfinnert@amazon.com>)
List pgsql-hackers
Tree view 
On 25 August 2018 at 04:05, Finnerty, Jim <jfinnert@amazon.com> wrote:
> I'll explore a proper way to test that it's in the single-relation case, and will post a separate thread for the
'removeunnecessary DISTINCT' optimization.
 

See: has_multiple_baserels() in allpaths.c

-- 
 David Rowley                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

pgsql-hackers by date:

Previous
From: Thomas Munro
Date:
Subject: Re: simplehash.h comment
Next
From: Michael Paquier
Date:
Subject: Re: [HACKERS] Proposal to add work_mem option to postgres_fdw module