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 1rzjrF-006Lqk-UA for pgsql-hackers@arkaria.postgresql.org; Wed, 24 Apr 2024 21:08:49 +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 1rzjrE-0008hC-2t for pgsql-hackers@arkaria.postgresql.org; Wed, 24 Apr 2024 21:08:48 +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 1rzjrD-0008h4-Pc for pgsql-hackers@lists.postgresql.org; Wed, 24 Apr 2024 21:08:47 +0000 Received: from mail-io1-xd36.google.com ([2607:f8b0:4864:20::d36]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rzjr9-002m2L-5N for pgsql-hackers@postgresql.org; Wed, 24 Apr 2024 21:08:47 +0000 Received: by mail-io1-xd36.google.com with SMTP id ca18e2360f4ac-7da42caa377so16093639f.3 for ; Wed, 24 Apr 2024 14:08:42 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1713992921; x=1714597721; darn=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=Zb3PMqYRJ13oRAUlrLPkxJehReFVMXCu2m5tSd4udig=; b=WhjcTVCvDxucGw0vXhIAnOUN9e+rz2UZkAg/u5KQjttBVZcJqgWbhTziXeX/0zbz49 iYMt6nPaWRm+Su/0TVuSMhhUpK3/ZOrx7yCTT7fLFi5Z0oP/Lu+D7YZ56l1tlfsymma+ D3O4LgbKGrodPR4+5E5EBBO9CaOGWgT+QgYiLS03vDhcYEjj2NYt+9cvm7kRYc8/lB9t x1eNfEVNSbpACXK54GSIsmJ1x0VzS91efI7ObUjcecHdGXRzeV5F4vnLFmMXCJPUzza/ 1duoyKGk3rPQ64FIyaq1ubMVmbBlVxA1RoTlvwG4WqNtjzZJhnFlVbwfZ06ujTalaClI Fz/g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1713992921; x=1714597721; 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=Zb3PMqYRJ13oRAUlrLPkxJehReFVMXCu2m5tSd4udig=; b=hDvqtfvjxO+v0i3rUQsfQpmSfQ4KmyLizINPkCT5QSJc0fWEY0JinAF5wy6MkuJblY tBlU5ZD1SF1s+lVJwpX+RRQahAiKE5SNMytqoCEChmBi/51lm2i5eB8aZP0fKIRuUctr yGXqKPhaJToS1gH6BwDLVQFZftn5if09aLtUIf6TbBGuCgZ7coFtxNloIv2HZ8cHKlMc 09+LEY8WhRZTTMEOVzERdkjWsfYj1xwvZmyoF1V5aljmXOjhQjx7EfbUCJHuk5+fMuqo sqv7oN/auHxa4vQFLYTIxf1wjOZryXBnY2Z2qR7hRMZ5nzbHiyYRSQU2P546D/eZWubU Em6w== X-Forwarded-Encrypted: i=1; AJvYcCVw2Mp1xsZaaKt3mPPaUv8N2Av3oo5pAxaDiwrdlyeNaumD4XNue40rdLyCtArGdgbxUcJt9qKTOpTK1kAsGGkwt3TjhP930ZaYVQXL X-Gm-Message-State: AOJu0YwYt9/SeJJvhAKyARSQLN/JGhk3XFP2syiX/gxyEXLs5gegptZu 63KvpjeocSKHJya8vT2zjiTpEHeyeaL2xLG2ga3xOMIANsV7d+RT5X115g== X-Google-Smtp-Source: AGHT+IGYs7EYND7hSG7yqhKGgdQ74jfQkpUoua8ucV7hEWinOJ7JourgULwnyJ8kpFxPA7uAQWIX+w== X-Received: by 2002:a5e:c308:0:b0:7de:944b:4ab1 with SMTP id a8-20020a5ec308000000b007de944b4ab1mr2512282iok.17.1713992921127; Wed, 24 Apr 2024 14:08:41 -0700 (PDT) Received: from nathanxps13 (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id fa15-20020a056638618f00b00486f54a34besm431389jab.138.2024.04.24.14.08.40 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 24 Apr 2024 14:08:40 -0700 (PDT) Date: Wed, 24 Apr 2024 16:08:39 -0500 From: Nathan Bossart To: Tom Lane Cc: Yugo NAGATA , pgsql-hackers@postgresql.org Subject: Re: Extend ALTER DEFAULT PRIVILEGES for large objects Message-ID: <20240424210839.GA863220@nathanxps13> References: <20240424115242.236b499b2bed5b7a27f7a418@sraoss.co.jp> <3602391.1713930458@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <3602391.1713930458@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, Apr 23, 2024 at 11:47:38PM -0400, Tom Lane wrote: > On the whole I find this proposed feature pretty unexciting > and dubiously worthy of the implementation/maintenance effort. I don't have any particularly strong feelings on $SUBJECT, but I'll admit I'd be much more interested in resolving any remaining reasons folks are using large objects over TOAST. I see a couple of reasons listed in the docs [0] that might be worth examining. [0] https://www.postgresql.org/docs/devel/lo-intro.html -- Nathan Bossart Amazon Web Services: https://aws.amazon.com