Home > mailing lists

Join optimization - Mailing list pgsql-general

From	luis.roberto@siscobra.com.br
Subject	Join optimization
Date	July 11, 2020 20:20:24
Msg-id	2028783297.11609965.1594488024498.JavaMail.zimbra@siscobra.com.br Whole thread Raw
Responses	Re: Join optimization
List	pgsql-general

Tree view

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?

Thanks!

[1] https://blog.dbi-services.com/the-myth-of-nosql-vs-rdbms-joins-dont-scale/

[2] https://dbfiddle.uk/?rdbms=oracle_18&fiddle=a5afeba2fdb27dec7533545ab0a6eb0e

[3] https://dbfiddle.uk/?rdbms=postgres_13&fiddle=87c78b4e97fdbd87255efc2fc909ee62

pgsql-general by date:

From: Adrian Klaver
Date: 11 July 2020, 18:23:38
Subject: Re: Issue with timestamp without time zone datatype with default value as now()/localtimestamp

From: Brian Dunavant
Date: 11 July 2020, 20:43:54
Subject: Re: Listen/Notify feedback

Join optimization - Mailing list pgsql-general

Previous

Next