Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1t3L40-00C0Hs-7T for pgsql-general@arkaria.postgresql.org; Tue, 22 Oct 2024 20:01:08 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1t3L3x-002rT1-J0 for pgsql-general@arkaria.postgresql.org; Tue, 22 Oct 2024 20:01:05 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1t3L3x-002rSt-89 for pgsql-general@lists.postgresql.org; Tue, 22 Oct 2024 20:01:05 +0000 Received: from mail-oo1-xc2f.google.com ([2607:f8b0:4864:20::c2f]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1t3L3v-002L0b-5C for pgsql-general@lists.postgresql.org; Tue, 22 Oct 2024 20:01:04 +0000 Received: by mail-oo1-xc2f.google.com with SMTP id 006d021491bc7-5ebc22e6362so1365234eaf.2 for ; Tue, 22 Oct 2024 13:01:03 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1729627262; x=1730232062; darn=lists.postgresql.org; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :from:to:cc:subject:date:message-id:reply-to; bh=Ii/suv513MkCGATHZPxlDdJLaS0PA1hcF3OfR2UudWM=; b=Cf3x9g09bs+myMr6IQL+5LdS40Mm+fkDXEmIDS2jLGuCPDoCy5eiOmWpJ0bdvQviwb XnzPA9k4URxBZcm2PWD8Or3rN+djdBA5PBbCGKK/2G+kvGh2ziW334MHsBCg6WHYgVbB 0w4voICpySGceidl1nB2Yfffo9tuwiu5J2BUT2mh3A8R86oZtsCmw39ceacoXLQz8jGT jymDQVddrighm/qoTPWoDU6WmSt1dMgbK52/QPjJgZMxXWNMn9v7ovkHNntfozE/yx0U I0hQi7m3zFvAKA5AsbfqljTGRJXI9FWT/l7M6HktHrLu16e3QOmIzK4yb5+N0abrLZQL 6eqA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1729627262; x=1730232062; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=Ii/suv513MkCGATHZPxlDdJLaS0PA1hcF3OfR2UudWM=; b=ONcvGK+RJSSbMC5rOFGI7/KHhzol9KR1HavzmgtnIjE5/K3xoUr6feaiWySxj8Jdkb lyOnagGJtQnsDoX/Bqmxdy0pjJVHPSQNvRtpMOb8j5WdpHUtZ1cYAOeHLmjoslOGkdnR 0k98drHVtjvAapUjsDb+I1uxuC0TcSgppdFEm+Mp3lQYG3RONXYVKSFeevW/YIG4eC8g XhnT0c9vNOg2iYB6yrzrDITUenYoe9nk7A5fpjGFKpHOGn1iUFJlJ/umsgpQ1OCkSutV dBxGg0IfS0QMb1XZ+JPSmxWycvx1lXEIrPS/E4bk5OBMen35cN9LMj2qBoEdS47Xdx84 sTmg== X-Gm-Message-State: AOJu0YwMkdJ923WK+r2y9IKxLcvjzMD+46lhdC9qZpEf7AZcilonwpQd QI9GOCxMN0hdOukQxVrOj/26D0j+WutWY2qlZPV9FbWeCVpDSk00ZvfNghHqCQyqPofC5PN2RPf Yq7wQGQt/8tRUR/7Y7xtIn0i8YAukRA== X-Google-Smtp-Source: AGHT+IGJRn4u4euHCwtgfpQh/ccq2c9+pjV2MTkTsU73MWVCG99nA6hnzspigCRyJaNQeXn6yMXzUA3eMIcSy/2rLuY= X-Received: by 2002:a05:6820:541:b0:5e5:d0c8:8030 with SMTP id 006d021491bc7-5ebee8e372emr182163eaf.3.1729627261975; Tue, 22 Oct 2024 13:01:01 -0700 (PDT) MIME-Version: 1.0 References: <20241016213610.wbfqj3r7gg5ba6eh@hjp.at> In-Reply-To: From: Ron Johnson Date: Tue, 22 Oct 2024 16:00:50 -0400 Message-ID: Subject: Re: Query performance issue To: "pgsql-generallists.postgresql.org" Content-Type: multipart/alternative; boundary="0000000000008b45650625163a33" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000008b45650625163a33 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Tue, Oct 22, 2024 at 3:02=E2=80=AFPM Greg Sabino Mullane wrote: [snip] > * Don't use the "FROM table1, table2, table3" syntax but use "FROM table1 > JOIN table2 ON (...) JOIN table3 ON (...) > Why? --=20 Death to , and butter sauce. Don't boil me, I'm still alive. crustacean! --0000000000008b45650625163a33 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Tue, Oct 22, 2024 at 3:02=E2=80=AFPM G= reg Sabino Mullane <htamfids@gmail= .com> wrote:
[snip]=C2=A0
* Do= n't use the "FROM table1, table2, table3" syntax but use &quo= t;FROM table1 JOIN table2 ON (...) JOIN table3 ON (...)

Why?

--
Death to <Redacted>, and butter sa= uce.
Don't boil me, I'm still alive.
<Redacted&= gt; crustacean!
--0000000000008b45650625163a33--