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 1qfcE3-00CKzl-Ss for pgsql-performance@arkaria.postgresql.org; Mon, 11 Sep 2023 08:24:55 +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 1qfcE1-00Emy3-Pg for pgsql-performance@arkaria.postgresql.org; Mon, 11 Sep 2023 08:24:53 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qfcE1-00Emxq-CE for pgsql-performance@lists.postgresql.org; Mon, 11 Sep 2023 08:24:53 +0000 Received: from mail-lf1-x130.google.com ([2a00:1450:4864:20::130]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qfcDx-004PhG-VR for pgsql-performance@postgresql.org; Mon, 11 Sep 2023 08:24:52 +0000 Received: by mail-lf1-x130.google.com with SMTP id 2adb3069b0e04-502984f5018so5458082e87.3 for ; Mon, 11 Sep 2023 01:24:49 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1694420689; x=1695025489; darn=postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=/hN1OhLBXtAEswLSUIxwPAfwARoB/VrgPKE+PpdlFaw=; b=sAvcNPHEomB7zMSoEQdlrBuazYPQkxGgavTW1BnZpI4d5naCPdB1stpIgprgAk6o22 DTbuI5NOq+E+3iRXsaTN6pUjfEXLJ7Af8y81EpmBfJ7VpFGBZkFF+cN8jmhPz023FadE AgtFu4IZVXNFgXY6hJTp0/OG3qoQpR9+HD8SYYJgp9JHgDsMlH2CvUuOZDlcHsFuJLuM Pc6yIRLQEXuqdTsq9v8YdIyCZbi6OObhqFNOiYU0RqWt169kjZbB51Cu+UK+5+2T0Pod z9iaEQKQJ587+DgSMwZz7aVdzQpmIhSuATxLCWT3zCXUSorlMNmWoJWltGKfedO5hxmC WKlw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1694420689; x=1695025489; h=cc: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=/hN1OhLBXtAEswLSUIxwPAfwARoB/VrgPKE+PpdlFaw=; b=ez7qeg4DpU1F01Cp6QF5bKULVfRzqDi6hyQbAh1eflHNJUtNLQO7uv3SYhhOMxDop1 c5svlOn0zaQ/wNNWIYF0YRunA2EqW1W29xkRgTf4Tx4zFCtXkAaC+2LpnJ0PQ1Y9Xmfn onCDzY5PhZPyyslILzQG//qxrPTqoeihp8K3IYcePQywQNm+XbqAATGWz6beWlaTp8wy sLat8n4Vj0dPb/Fk3Glftj/HeR3GA0hZyDlbDbBG3U1xV9bKmvGmqkmxhXZkAeyHE8dn 3oGFC1RQBXhwZSnaNTEBxHCho+6H8cHHL3QCrl9rn1LJZLkVAt4AtkRjjd8lC8Z0Xkmp JKpw== X-Gm-Message-State: AOJu0Yw/a4rmAK4EAsaaiDtOdLW1w4K/ouA3C0gLoalX7JVilRn6pboy RtIqUrwNqHPMjYPyMrriYEWiFr0CGzMlBgWdPR8= X-Google-Smtp-Source: AGHT+IEGhZTwKTKtA37yNv/TWyp9AF2oQkc9tBsY9xte56/pApkag441f6U/98Wr1tQm98950sdDVeexL1tpEijZghk= X-Received: by 2002:a05:6512:31cb:b0:4ff:8863:be01 with SMTP id j11-20020a05651231cb00b004ff8863be01mr7998586lfe.8.1694420688692; Mon, 11 Sep 2023 01:24:48 -0700 (PDT) MIME-Version: 1.0 References: <5ef3acf5733d5a8584b09eb5dd107e59aa87a075.camel@cybertec.at> In-Reply-To: <5ef3acf5733d5a8584b09eb5dd107e59aa87a075.camel@cybertec.at> From: David Rowley Date: Mon, 11 Sep 2023 20:24:35 +1200 Message-ID: Subject: Re: Planning time is time-consuming To: Laurenz Albe Cc: Mikhail Balayan , pgsql-performance@postgresql.org Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, 11 Sept 2023 at 18:16, Laurenz Albe wrote: > Also, there are quite a lot of indexes on "test_db_bench_1". On a test database, drop some > indexes and see if that makes a difference. Yeah, I count 3 that either have the key columns as some prefix of another index or are just a duplicate of some other index. Getting rid of those 3 will save some time in create_index_paths(). David