Postgres Pro
Downloads
Home   >   mailing lists

pgsql-server/src/backend/optimizer/util pathnode.c - Mailing list pgsql-committers

From tgl@svr1.postgresql.org (Tom Lane)
Subject pgsql-server/src/backend/optimizer/util pathnode.c
Date
Msg-id 20040119034941.D90A3D1E81E@svr1.postgresql.org
Whole thread Raw
List pgsql-committers
Tree view 
CVSROOT:    /cvsroot
Module name:    pgsql-server
Changes by:    tgl@svr1.postgresql.org    04/01/18 23:49:41

Modified files:
    src/backend/optimizer/util: pathnode.c

Log message:
    Recognize that IN subqueries return already-unique results if they use
    UNION/INTERSECT/EXCEPT (without ALL).  This adds on to the previous
    optimization for subqueries using DISTINCT.

pgsql-committers by date:

Previous
From: tgl@svr1.postgresql.org (Tom Lane)
Date:
Subject: pgsql-server/src backend/utils/fmgr/dfmgr.c ba ...
Next
From: tgl@svr1.postgresql.org (Tom Lane)
Date:
Subject: pgsql-server/src/backend/optimizer/path costsize.c