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 1rngJ2-00EVNY-OM for pgsql-hackers@arkaria.postgresql.org; Fri, 22 Mar 2024 14:55:41 +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 1rngJ1-004OOn-7z for pgsql-hackers@arkaria.postgresql.org; Fri, 22 Mar 2024 14:55:39 +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 1rngJ0-004OOf-VD for pgsql-hackers@lists.postgresql.org; Fri, 22 Mar 2024 14:55:39 +0000 Received: from mail-io1-xd2a.google.com ([2607:f8b0:4864:20::d2a]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rngIy-005v8y-64 for pgsql-hackers@lists.postgresql.org; Fri, 22 Mar 2024 14:55:38 +0000 Received: by mail-io1-xd2a.google.com with SMTP id ca18e2360f4ac-7c8bb44622eso68033439f.0 for ; Fri, 22 Mar 2024 07:55:35 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1711119334; x=1711724134; 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=PZdBaIVyehb0mzbsMqWSZq8nxM4RYfaQE9oVozhiEYw=; b=O2OH6HVSavJbmIJYLS8zO7qyCH/gmDkSmXl0gWBwTUtMcx5lRgbxiBmF/ikC44PWJ6 FMTARa8YLu6Ido5jP9jCMppScv0CQQBj9fPjZVRUzd6Gj0DBUH70Y6PET6SS+cmcAYf+ WwFQVKkAT+eqP3UVtl6h3ug7hFzQV6cTEwEp3fLT2JE15qnBRpJBqYfakp4FxuzJhcyl ScUswYHLBDL9Rm5yMRpocvqsdfqhbbC09AuwlhZFufpQUM4k+tvsL5sGTVyng2Kkf5pr B343ob/7aT/zx245dliMILUSPLx+DH43lTg4ZZpcRLrH772PtAfzoObmBQ5jYFJE0jD1 WZsQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1711119334; x=1711724134; 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=PZdBaIVyehb0mzbsMqWSZq8nxM4RYfaQE9oVozhiEYw=; b=K9Zk8WBdnRo+sLAjfq+uxX4zylmDASkhX3CqDz1NSA3Ur+NgVOmnJ5foDn/Exm3vLv Y6IsEmCszYBq9Ax081mQN2Ue2k9kHmuRNVKHkJxIzkxcNfqsXR4tBtLTiF7iOmD1DpGl rVBScI/EK5iMrM8ADK/XBk/8QPudKe/MDzV3zw5376SRTJpVVbTOEPbpOm58hCxnwCtw CRpm5AmErVWlXplMH78bo+uD+GuCQgvCA5ejJuDMRZh/ts8U/cxzvYT7M1j1LacupYaF aSypUXl+BOnCut1NkhPTVElMP4dus+Xp81olFLiltA6K+KSIV0auCC7oCR/3tjWeWg1t 3Qow== X-Gm-Message-State: AOJu0Yyz7DgRM+kFCZNQbIaxP4Qs+pu06jh4cIf3hqCRmZnlv/mrPdGv vI0BdMW41bBr8KM4w9aIvZ+HIway8UEhLFwzzgg8gcI1WhvbalR2 X-Google-Smtp-Source: AGHT+IGYDgcl9DkUR4NhkLuy2n9bp0YevIUh2SUIrtVl/6xaLnN1g11tz+05nFmC57stpjFiXYnSwA== X-Received: by 2002:a5e:9911:0:b0:7cf:c51d:2d89 with SMTP id t17-20020a5e9911000000b007cfc51d2d89mr3199099ioj.3.1711119334014; Fri, 22 Mar 2024 07:55:34 -0700 (PDT) Received: from nathanxps13 (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id q16-20020a02c8d0000000b00477b9971a45sm564120jao.17.2024.03.22.07.55.33 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 22 Mar 2024 07:55:33 -0700 (PDT) Date: Fri, 22 Mar 2024 09:55:32 -0500 From: Nathan Bossart To: Tom Lane Cc: pgsql-hackers@lists.postgresql.org, alex work , Robert Haas Subject: Re: Slow GRANT ROLE on PostgreSQL 16 with thousands of ROLEs Message-ID: <20240322145532.GA2346110@nathanxps13> References: <341186.1711037256@sss.pgh.pa.us> <619340.1711050134@sss.pgh.pa.us> <642442.1711053105@sss.pgh.pa.us> <20240321204012.GA1992418@nathanxps13> <20240322005139.GA2060816@nathanxps13> <806361.1711069194@sss.pgh.pa.us> <20240322144739.GA2321246@nathanxps13> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20240322144739.GA2321246@nathanxps13> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, Mar 22, 2024 at 09:47:39AM -0500, Nathan Bossart wrote: > hash hash+simd hash+simd+bloom > create 1.27 1.27 1.28 > grant 0.18 0.11 0.03 For just hash+bloom, I'm seeing 1.29 and 0.04. -- Nathan Bossart Amazon Web Services: https://aws.amazon.com