| From: | luis(dot)roberto(at)siscobra(dot)com(dot)br |
|---|---|
| To: | pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Join optimization |
| Date: | 2020-07-11 17:20:24 |
| Message-ID: | 2028783297.11609965.1594488024498.JavaMail.zimbra@siscobra.com.br |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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/ | https://blog.dbi-services.com/the-myth-of-nosql-vs-rdbms-joins-dont-scale/ ]
[2] [ https://dbfiddle.uk/?rdbms=oracle_18&fiddle=a5afeba2fdb27dec7533545ab0a6eb0e | https://dbfiddle.uk/?rdbms=oracle_18&fiddle=a5afeba2fdb27dec7533545ab0a6eb0e ]
[3] [ https://dbfiddle.uk/?rdbms=postgres_13&fiddle=87c78b4e97fdbd87255efc2fc909ee62 | https://dbfiddle.uk/?rdbms=postgres_13&fiddle=87c78b4e97fdbd87255efc2fc909ee62 ]
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Brian Dunavant | 2020-07-11 17:43:54 | Re: Listen/Notify feedback |
| Previous Message | Marlene Villanueva | 2020-07-11 17:15:27 | Re: Request to help on Query improvement suggestion. |