Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1p850l-00036U-Hw for pgsql-hackers@arkaria.postgresql.org; Wed, 21 Dec 2022 19:44:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1p850k-0000jo-7F for pgsql-hackers@arkaria.postgresql.org; Wed, 21 Dec 2022 19:44:18 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1p850j-0000i8-PA for pgsql-hackers@lists.postgresql.org; Wed, 21 Dec 2022 19:44:17 +0000 Received: from mail-io1-xd2d.google.com ([2607:f8b0:4864:20::d2d]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1p850h-0003M7-IM for pgsql-hackers@lists.postgresql.org; Wed, 21 Dec 2022 19:44:17 +0000 Received: by mail-io1-xd2d.google.com with SMTP id z144so8554774iof.3 for ; Wed, 21 Dec 2022 11:44:15 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=telsasoft-com.20210112.gappssmtp.com; s=20210112; h=user-agent: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=UszEsSDro+NdbT5Vfo3c0BL9lfiDlp0qPTkChdcTKY4=; b=Mr+qGuXIih2tf2bmsqott6UEmg6ib/1yugXbG5XDVGvVQxglUyP3aCixacJM5e3isM 0o0l+AVHAXeL7qhNd+MAvvmPUwi5QFzE1R9dh9YziiPYZUKBBBJcOupvPsT+YFsuQ8Rw ctnsL5adm9D4Au+IHP7cGNtaXa2c8D1uru9OC51qsGPTPgMoaV149mdquYjTS60QYUFC DBrB18DpRQhSJqaipJy8KU0YkW3tkIaEtmp2Ts3x/zr92pINDOpsWUFIIREzxMzdb+er NUdB52LeFXWy2PTy+wpl3Ps5yI7uKW6GuBn+95ucXURHHoWCLKJUvEBEdTfCAFvDFP1o 2aOw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=user-agent: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=UszEsSDro+NdbT5Vfo3c0BL9lfiDlp0qPTkChdcTKY4=; b=HYLFGWbO5L/vmoPsx1ypw+n7MPV79fPtwRlRrqcNUb7R8tyZc/iOwsYIE2FRo1k0Tv ne3Hd7ma5FONePCKcrVByAQIG9+eUcbMnXPC6rQ9rHw2UwEQLhs7GTL5QW9drf2FsmdX uPk30b5XDhefBBuYGP4+DX/FAU1HNChsnTaz/G/XB3qBWyJthhNMW6+ZzZXpHO6l802v M71oSP4kozVor0R2wqOc0nrwYknaUGKsVF2v8C36DeVs+dHVfLVYyuViTueurdQHGWZu zTxT4H5tRkVkbxcOzXbPxjg7wccXyhU6p03rhbzpScB1T8rg90dZf1h6L71FCtLvZAMi leHw== X-Gm-Message-State: AFqh2kod6s7tS6XdBRogs+aQoaifTdeSG2VjXNEYDpVKbElrHbcUGhL6 xfW9ySWfgR7yprq8FoIHhXVUog== X-Google-Smtp-Source: AMrXdXv2oI7b0mR4xtKxa+uQvdRMjhNTz+DZRWQHlnWJQY+pLEPb/MgQMBKxKyO3N5xF0I5X2yMiFQ== X-Received: by 2002:a5d:9c0b:0:b0:6df:e78e:1aaa with SMTP id 11-20020a5d9c0b000000b006dfe78e1aaamr1717977ioe.16.1671651852807; Wed, 21 Dec 2022 11:44:12 -0800 (PST) Received: from pryzbyj.telsasoft (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id i1-20020a056602134100b006a129b10229sm6542284iov.31.2022.12.21.11.44.12 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 21 Dec 2022 11:44:12 -0800 (PST) Received: by pryzbyj.telsasoft (Postfix, from userid 1000) id 410788007F5; Wed, 21 Dec 2022 13:44:11 -0600 (CST) Date: Wed, 21 Dec 2022 13:44:11 -0600 From: Justin Pryzby To: Amit Langote Cc: Alvaro Herrera , Ian Lawrence Barwick , Tom Lane , David Rowley , Greg Stark , Julien Rouhaud , pgsql-hackers@lists.postgresql.org Subject: Re: ExecRTCheckPerms() and many prunable partitions (checkAsUser) Message-ID: <20221221194411.GM1153@telsasoft.com> References: <20221129092708.uooopfzpiwrhgedl@alvherre.pgsql> <20221210201753.GA27893@telsasoft.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.9.4 (2018-02-28) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Alvaro could you comment on this ?