Message-ID: <7fd675e06f99fc29f9c7c738b1d688c53f4f4f06.camel@cybertec.at>
Subject: Re: Query performance issue
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: "David G. Johnston" <david.g.johnston@gmail.com>, Ron Johnson
	 <ronljohnsonjr@gmail.com>
Cc: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Date: Tue, 22 Oct 2024 22:47:11 +0200
In-Reply-To: <CAKFQuwbV33pOEdayvCaOrgm+qYfVgpnTr8KP-katfxnDfQ+cQg@mail.gmail.com>
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>
	 <CAKFQuwbV33pOEdayvCaOrgm+qYfVgpnTr8KP-katfxnDfQ+cQg@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.52.4 (3.52.4-1.fc40) 
MIME-Version: 1.0
Archived-At: <https://www.postgresql.org/message-id/7fd675e06f99fc29f9c7c738b1d688c53f4f4f06.camel%40cybertec.at>
Precedence: bulk

On Tue, 2024-10-22 at 13:06 -0700, David G. Johnston wrote:
> On Tue, Oct 22, 2024 at 1:01=E2=80=AFPM Ron Johnson <ronljohnsonjr@gmail.=
com> wrote:
> > On Tue, Oct 22, 2024 at 3:02=E2=80=AFPM Greg Sabino Mullane <htamfids@g=
mail.com> wrote:
> > > * Don't use the "FROM table1, table2, table3" syntax but use "FROM ta=
ble1 JOIN table2 ON (...) JOIN table3 ON (...)
> >=20
> > Why?
>=20
> Readability is improved when done correctly; and you need to know it for =
outer joins anyway, so consistency.

Also, you cannot accidentally forget a join condition.

Yours,
Laurenz Albe