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 1rShC6-00FKkC-5m for pgsql-hackers@arkaria.postgresql.org; Wed, 24 Jan 2024 17:37:46 +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 1rShC2-006wut-MO for pgsql-hackers@arkaria.postgresql.org; Wed, 24 Jan 2024 17:37:42 +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 1rShC2-006wuj-Cd for pgsql-hackers@lists.postgresql.org; Wed, 24 Jan 2024 17:37:42 +0000 Received: from mail-il1-x12c.google.com ([2607:f8b0: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 1rShBz-003A9V-Tl for pgsql-hackers@lists.postgresql.org; Wed, 24 Jan 2024 17:37:41 +0000 Received: by mail-il1-x12c.google.com with SMTP id e9e14a558f8ab-3608aa647bfso25907405ab.3 for ; Wed, 24 Jan 2024 09:37:39 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1706117859; x=1706722659; darn=lists.postgresql.org; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:from:to:cc:subject:date:message-id:reply-to; bh=G0Hq29IXQn7mOIKavuwwaxTMYiobVNbNHQMJxdUITUs=; b=H3RQHSxo7K/gkP29cVCburgVPCg7B1V9jPRNHh4SecCXj6fwkJJjwbLFtAZGaoxOYk YOPsiagj+sHEV64Qm9jC0hQK5soUvgbsRrJ63q+H345cJIboWacew9WR2z71DNfXYNHO EQezVV/479CJb4Hp4XjGpaB3oxgE+Wl74PWrCXlAZ6aBH/0gRO+u0TbLFKZqBn+1aGV7 ZGUqIJkUc2Syb1DUdiAd4F91Wx/9gwYpoTS5wOGQetOOJ5VE+533yUoexRp8OWj4N0sh s0gi8NdOm28tPDLg2rG5fVnl4L+k0GoE0/nEZpLKtylMlfFQEPNL3uuih+cyte/cJPLB 7S8A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1706117859; x=1706722659; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=G0Hq29IXQn7mOIKavuwwaxTMYiobVNbNHQMJxdUITUs=; b=T6jl130QZUmawf2oy/FzRjOJ213Xvi4u3e2Ho6L1D7dx0zHmkvqWVkXyNT2oKyQJFH UFd6q/+pj51UlxSRQIXQvd/12JoLAHvHVNualA81EJtTKjbWdRZQN91/89QQY+B19z7H eTnqkTpGPInTgn48zRvgBUAAH8XlreeZ5KFGz/T67F/GOiz5iajDH1FIbdVlGguemt/4 l5k0rY2UMzyw5ThEBqBJbszRUfYFs255S/48xLlITtPKFqPN9RbD73S5fkJUW6/C5TPA U1kz/fekoDnpuZ9Y4MWMd/BOAuKi1hZKldq898Kc8vRkr+a8yxWJ6gEXcau+U9qktARv aQ8Q== X-Gm-Message-State: AOJu0Yx9tuVNjtDidGJVjPoFlhdqs53iXmw+PODavSd2h3R9Dg8MZxOE VFECky625sejQow5Q7M3T9+Z+OFt15vzGwgylqIRf9eCjRB+zhII X-Google-Smtp-Source: AGHT+IHmXmOdNJL1dtjyHryGsCcV2N8NM4lyYkqII/+uapgCcE1Y8q9abbSRtxhQJKCLvOE2cC9sEg== X-Received: by 2002:a05:6e02:154b:b0:361:9316:7183 with SMTP id j11-20020a056e02154b00b0036193167183mr2354830ilu.46.1706117858270; Wed, 24 Jan 2024 09:37:38 -0800 (PST) Received: from nathanxps13 (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id a6-20020a056e020e0600b00361a806e915sm4265133ilk.19.2024.01.24.09.37.37 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 24 Jan 2024 09:37:37 -0800 (PST) Date: Wed, 24 Jan 2024 11:37:35 -0600 From: Nathan Bossart To: Alexander Korotkov Cc: Andrei Lepikhov , Richard Guo , Pavel Borisov , vignesh C , PostgreSQL Developers , Tomas Vondra , Teodor Sigaev , David Rowley , "a.rybakina" , Tom Lane Subject: Re: POC: GROUP BY optimization Message-ID: <20240124173735.GA2708416@nathanxps13> References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk A recent buildfarm failure [0] seems to indicate a name collision with the "abc" index in the aggregates.sql test and the "abc" table in namespace.sql. [0] https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=piculet&dt=2024-01-24%2014%3A05%3A14 -- Nathan Bossart Amazon Web Services: https://aws.amazon.com