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 1t0igv-00CrHM-OU for pgsql-hackers@arkaria.postgresql.org; Tue, 15 Oct 2024 14:38:29 +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 1t0igt-007Q1e-FD for pgsql-hackers@arkaria.postgresql.org; Tue, 15 Oct 2024 14:38:27 +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 1t0igs-007Q1U-T3 for pgsql-hackers@lists.postgresql.org; Tue, 15 Oct 2024 14:38:27 +0000 Received: from mail-lf1-x12c.google.com ([2a00:1450:4864:20::12c]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1t0igq-0011AQ-Hc for pgsql-hackers@postgresql.org; Tue, 15 Oct 2024 14:38:26 +0000 Received: by mail-lf1-x12c.google.com with SMTP id 2adb3069b0e04-539e6c754bdso2677179e87.2 for ; Tue, 15 Oct 2024 07:38:24 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1729003103; x=1729607903; darn=postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=3NbeFOl93K8HbQW15cn+P7t9YtUchoY5QzPm/B2zrmc=; b=hGDBjwY+7evHGp/jJ81IuHsyi6Gg4qv7uKGOoVlWMawV+zOVP8FZI3V/U00fdxnsaB 3T1zeNH9zAPE6k2GGCmvtVkE9sAHSCooiu0V33fwIkcDUwGjiRO4EPh+C8jtzpICicqf eoa9lTVltHmoohoX4XlT2XcSm84L26PjLGRUV2nX6EzUxa5swQkMgW2NRu2toG2gjKIF kp1HjZ8JT5DgAXoYXx4jacKzZsaQVJr9QJ+C7/5oTH3gnX5YKW1DVstgMvPbL+hPjtpC eE4xDkIqzPEgWLBeaAY9mdDsr1mLH3p3ZrZ1JFpC9MoapBQClyYJcQD+xmgGV8LRBLGS flCw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1729003103; x=1729607903; h=content-transfer-encoding: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=3NbeFOl93K8HbQW15cn+P7t9YtUchoY5QzPm/B2zrmc=; b=nUg5DYtt136bOgkFNMeYx+/w4fFpFJUKQOAF9ne1yRd3ZYvoRoqtVND3T8DUTHo0Jv YgzN9lW4QkK4y0wqRvaz6yq9G9WJ0ogKO/DQH5K3dsvhUv0AVarp6bDc/iHHYhh4UYZT Ot3+jaBVanAjIv7DCX9iG6OFLCIgPVWYBFxP/hJxuRBUl6sE1uBtChUk2DhQ5UGJ6jPe 2c1+xrdvOZFTIyIVMu7E3ahazFNKUzwBQJTzZZX+X/fxOJfguSCNbsa1lbRyJ3ee/4RF RTyAs6/08XWQBUikGo6rnPVV/JO9WUxqttupj+N/XUqBC+wyOU5+wx7HOyET4Kfm69Th JEEg== X-Forwarded-Encrypted: i=1; AJvYcCXr2RPQQ8lNDqcltgXPUgTQfZiSi8R3C8k5m9vJT4MWhBeVORs/6ziv3A50waqNUZjFjEOJgP15n/ciXibk@postgresql.org X-Gm-Message-State: AOJu0Yz58391VxvQDEHTbVLwLBfSAukyR0bs0N4H3zNEfHIKSH1puM+m hgQrCL/Mt40/YoRG/tBPWvRCptPWZgMKhkKSAaD2XD1NCCrolRLlAxe9SQ24rnu3QTuzkstC4My dmycZ+BwAn36IRHQrr2N38bsCDmY= X-Google-Smtp-Source: AGHT+IEnK/229ua3XeuioXkhCru5bF7YOiKZyu3vfDH+EGYvy8OvQIDJmMlQ85rUV3hMu0hyyU22HYKYZl+hUEI42iU= X-Received: by 2002:a05:6512:2811:b0:539:f4ab:5638 with SMTP id 2adb3069b0e04-539f4ab57c9mr3519770e87.60.1729003102355; Tue, 15 Oct 2024 07:38:22 -0700 (PDT) MIME-Version: 1.0 References: <202406191709.jbvpf7d7hl6g@alvherre.pgsql> In-Reply-To: From: Robert Haas Date: Tue, 15 Oct 2024 10:38:10 -0400 Message-ID: Subject: Re: generic plans and "initial" pruning To: Amit Langote Cc: Alvaro Herrera , Andres Freund , Daniel Gustafsson , David Rowley , PostgreSQL Hackers , Thom Brown , Tom Lane Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, Oct 11, 2024 at 3:30=E2=80=AFAM Amit Langote wrote: > Maybe just "relids" suffices with a comment updated like this: > > * relids RelOptInfo.relids of the parent plan node (e.g. A= ppend > * or MergeAppend) to which his PartitionPruneInfo n= ode > * belongs. Used to ensure that the pruning logic ma= tches > * the parent plan's apprelids. LGTM. --=20 Robert Haas EDB: http://www.enterprisedb.com