Postgres Pro
Downloads
Home   >   mailing lists

Re: Join optimization - Mailing list pgsql-general

From Fabrízio de Royes Mello
Subject Re: Join optimization
Date
Msg-id CAPfkCSC-NmtwZVe5Q=KLVdk6V-b1OYS9XefbccizHuS37c4g1Q@mail.gmail.com
Whole thread Raw
In response to Join optimization  (luis.roberto@siscobra.com.br)
Responses Re: Join optimization
List pgsql-general
Tree view


Em sáb, 11 de jul de 2020 às 14:20, <luis.roberto@siscobra.com.br> escreveu:
Hi!

Recently on a blogpost [1] I saw that Oracle was able to "optimize" a join strategy by completely eliminating access to a table.

Heres the execution on Oracle 18c [2] and PostgreSQL 13 (beta) [3].

Is there a fundamental reason why PG can't do the same? 

It does... did you see the “never executed” notice on the Postgres explain output?

Regards,


--
   Fabrízio de Royes Mello         Timbira - http://www.timbira.com.br/
   PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento

pgsql-general by date:

Previous
From: Brian Dunavant
Date:
Subject: Re: Listen/Notify feedback
Next
From: luis.roberto@siscobra.com.br
Date:
Subject: Re: Join optimization