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 1rmGu9-006zwa-RY for pgsql-hackers@arkaria.postgresql.org; Mon, 18 Mar 2024 17:36:10 +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 1rmGu7-004bhM-S4 for pgsql-hackers@arkaria.postgresql.org; Mon, 18 Mar 2024 17:36:08 +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 1rmGr5-004YFh-Kc for pgsql-hackers@lists.postgresql.org; Mon, 18 Mar 2024 17:33:00 +0000 Received: from mail-io1-xd2d.google.com ([2607:f8b0:4864:20::d2d]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rmGr3-005DyG-7y for pgsql-hackers@lists.postgresql.org; Mon, 18 Mar 2024 17:32:59 +0000 Received: by mail-io1-xd2d.google.com with SMTP id ca18e2360f4ac-7cc0b35b75bso35728039f.3 for ; Mon, 18 Mar 2024 10:32:57 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1710783176; x=1711387976; 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=XA8hYEKJKp4DvkzedKy2iUTofwrqOGXnNNGDPILRIDU=; b=JOo9g4lrxKEt/uloURqk3FPErgZwKiiODCGNujYXhAvOviY4TTFK8iarFTMXGMY3cE 59MMmy1UYtkdlcMjKmtAIRpgDoJLfYfOl8Fo3E0n8b0UXDhnuu8vWoW4IkgDeMET/8hu cm8dDUgiMBg73BhTANE8mn8qj5QmeKF4huWBXNGy6o50xjK0X77sEW+KWLJHI6ilMH9w uLscm9ja/Qd9j3+WybiWJB+0t4uW+5egHtEWQwq/kUWn3l1paLXNig6LR1oM31G318k/ hoao5Wd6fofy4Xms53ri3EvzWLBaRN0HRh9Be5iAodbC7Hk5Ab7b/JsbST5KE/rZ9ZdG JMkw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1710783176; x=1711387976; 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=XA8hYEKJKp4DvkzedKy2iUTofwrqOGXnNNGDPILRIDU=; b=VKEXaqcPoLw365gtp6pe0xOtZcxjHl8o1DLpCCREF3uwgv3dD9fUthdhdr+2mSqM5d AmCrKqua+qcz2Jb/xLnc7/WhU/yEL3PdU/j1ehobVS7BL+ae90voUge6DXPjcoI+r/QG x3AC6Nf9ikolRa09CnpkokwuJc1cfcMKnPS0ce2fGhXJ+68CcGz+xegIf70cR+Hgm7Ir ZO8JJssUGRuTN9cCBA6+5VB8QfbsJnkCi1KrN2Oyl9QttqliWimt9GoMJ/vo3i7SnxhB J90K+SeXJwhoHnjEvTNLDo4IQfVPc9rskRjBfC0NbeGRnxurZShjqMO5SfBn5u26YYNP eFEg== X-Forwarded-Encrypted: i=1; AJvYcCV+vxn0rmJ7CK0Bfuy3RBGfwIrxgJWWJVF6D88bEJHjM/39b0mtbK35N1Tm+PIjgWgv++9pLu7nr/hBmUrMXb+f/z0okIJlBdxq8oxImZC6CHBt X-Gm-Message-State: AOJu0Yzi+tzsW4bN6CY5+mIsf6+pqaVXGia9ZgBWpaiYsJoR0ukzxxBy LG/7/PmaTlZ8haRgmJJRqxb7i8Mma20sGA1VmCFdi98q8dhK097R X-Google-Smtp-Source: AGHT+IGLVWWow2K7rjTKYT9FtqsksZKYxN3EnxS6b3gml0iQQ6oLNjWx6YW7t/UVblym02Yn4d7yGg== X-Received: by 2002:a5e:9507:0:b0:7cc:c0f:a71f with SMTP id r7-20020a5e9507000000b007cc0c0fa71fmr65520ioj.21.1710783175762; Mon, 18 Mar 2024 10:32:55 -0700 (PDT) Received: from nathanxps13 (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id v23-20020a5ec117000000b007cc83975ab8sm312126iol.47.2024.03.18.10.32.55 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 18 Mar 2024 10:32:55 -0700 (PDT) Date: Mon, 18 Mar 2024 12:32:53 -0500 From: Nathan Bossart To: "Amonson, Paul D" Cc: David Rowley , Andres Freund , Alvaro Herrera , "Shankaran, Akash" , Noah Misch , Tom Lane , Matthias van de Meent , "pgsql-hackers@lists.postgresql.org" Subject: Re: Popcount optimization using AVX512 Message-ID: <20240318173253.GB361138@nathanxps13> References: <20240307213600.GA563369@nathanxps13> <20240312013436.GA1787866@nathanxps13> <20240315150611.GA3495582@nathanxps13> <20240318152902.GA2850@nathanxps13> <20240318162018.GA204772@nathanxps13> 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 On Mon, Mar 18, 2024 at 05:28:32PM +0000, Amonson, Paul D wrote: > Question: I applied the patch for the drive_popcount* functions and > rebuilt. The resultant server complains that the function is missing. > What is the trick to make this work? You probably need to install the test_popcount extension and run "CREATE EXTENION test_popcount;". > Another Question: Is there a reason "time psql" is used over the Postgres > "\timing" command? I don't think there's any strong reason. I've used both. -- Nathan Bossart Amazon Web Services: https://aws.amazon.com