MIME-Version: 1.0
References: <CAEzWdqfeaLov=e3Dk_wMpzh0yWhGcVJhundmL=QL1X_KqG_Jfw@mail.gmail.com>
 <20241016213610.wbfqj3r7gg5ba6eh@hjp.at> <CAEzWdqdDTPxxzQYJfr_RdJTtLx-kNnc__z8f9nB25wVQuKzapg@mail.gmail.com>
 <CAKAnmmKMzXaUeVg-WLVReCOD-=+8GUq8=Uc7a0jfU6DgzPZ_Yg@mail.gmail.com> <CANzqJaDpTOQ3d8JaMP90dRjqBM3NQozxL2eovOsfQKqFJOcLiA@mail.gmail.com>
In-Reply-To: <CANzqJaDpTOQ3d8JaMP90dRjqBM3NQozxL2eovOsfQKqFJOcLiA@mail.gmail.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Tue, 22 Oct 2024 13:06:20 -0700
Message-ID: <CAKFQuwbV33pOEdayvCaOrgm+qYfVgpnTr8KP-katfxnDfQ+cQg@mail.gmail.com>
Subject: Re: Query performance issue
To: Ron Johnson <ronljohnsonjr@gmail.com>
Cc: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000b9ae3d0625164f6d"
Archived-At: <https://www.postgresql.org/message-id/CAKFQuwbV33pOEdayvCaOrgm%2BqYfVgpnTr8KP-katfxnDfQ%2BcQg%40mail.gmail.com>
Precedence: bulk

--000000000000b9ae3d0625164f6d
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Tue, Oct 22, 2024 at 1:01=E2=80=AFPM Ron Johnson <ronljohnsonjr@gmail.co=
m> wrote:

> On Tue, Oct 22, 2024 at 3:02=E2=80=AFPM Greg Sabino Mullane <htamfids@gma=
il.com>
> wrote:
> [snip]
>
>> * Don't use the "FROM table1, table2, table3" syntax but use "FROM table=
1
>> JOIN table2 ON (...) JOIN table3 ON (...)
>>
>
> Why?
>
>
Readability is improved when done correctly; and you need to know it for
outer joins anyway, so consistency.

David J.

--000000000000b9ae3d0625164f6d
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><div class=3D"gmail_default" style=3D"fon=
t-family:arial,helvetica,sans-serif"><span style=3D"font-family:Arial,Helve=
tica,sans-serif">On Tue, Oct 22, 2024 at 1:01=E2=80=AFPM Ron Johnson &lt;<a=
 href=3D"mailto:ronljohnsonjr@gmail.com">ronljohnsonjr@gmail.com</a>&gt; wr=
ote:</span></div></div><div class=3D"gmail_quote"><blockquote class=3D"gmai=
l_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,20=
4,204);padding-left:1ex"><div dir=3D"ltr"><div dir=3D"ltr">On Tue, Oct 22, =
2024 at 3:02=E2=80=AFPM Greg Sabino Mullane &lt;<a href=3D"mailto:htamfids@=
gmail.com" target=3D"_blank">htamfids@gmail.com</a>&gt; wrote:<br></div><di=
v class=3D"gmail_quote"><div>[snip]=C2=A0</div><blockquote class=3D"gmail_q=
uote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,2=
04);padding-left:1ex"><div dir=3D"ltr">* Don&#39;t use the &quot;FROM table=
1, table2, table3&quot; syntax but use &quot;FROM table1 JOIN table2 ON (..=
.) JOIN table3 ON (...)<br></div></blockquote><div></div></div><div><br></d=
iv>Why?<br clear=3D"all"><div><br></div></div></blockquote><div><br></div><=
div class=3D"gmail_default" style=3D"font-family:arial,helvetica,sans-serif=
">Readability is improved when done correctly; and you need to know it for =
outer joins anyway, so consistency.</div><div class=3D"gmail_default" style=
=3D"font-family:arial,helvetica,sans-serif"><br></div><div class=3D"gmail_d=
efault" style=3D"font-family:arial,helvetica,sans-serif">David J.</div><div=
 class=3D"gmail_default" style=3D"font-family:arial,helvetica,sans-serif"><=
br></div></div></div>

--000000000000b9ae3d0625164f6d--