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 1sr7Oq-00FVLZ-Kc for pgsql-hackers@arkaria.postgresql.org; Thu, 19 Sep 2024 03:00:08 +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 1sr7Oo-002RVX-SL for pgsql-hackers@arkaria.postgresql.org; Thu, 19 Sep 2024 03:00:06 +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 1sr7Oo-002RUL-Hl for pgsql-hackers@lists.postgresql.org; Thu, 19 Sep 2024 03:00:06 +0000 Received: from mail-lj1-x229.google.com ([2a00:1450:4864:20::229]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sr7Om-001vOX-BK for pgsql-hackers@postgresql.org; Thu, 19 Sep 2024 03:00:05 +0000 Received: by mail-lj1-x229.google.com with SMTP id 38308e7fff4ca-2f75c56f16aso4116051fa.0 for ; Wed, 18 Sep 2024 20:00:04 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1726714803; x=1727319603; darn=postgresql.org; h=content-transfer-encoding:in-reply-to:references:cc:to:from :content-language:subject:user-agent:mime-version:date:message-id :from:to:cc:subject:date:message-id:reply-to; bh=1804u5LFTDn9Fw2OOJVq8y75LWua8ousONYhS9QwGmo=; b=jujTBIULSpJljiH9KdP9DDvzkU83zRoqnGdA+520svhCay4sD+qnKxY946JtPefapk nzbjnmBJJWTPSrPta+0l7ZprsmOz1GgU/K+aaUonFf8p3nVyXVnKIjYpXDgV1wu8xJxK 4F6uEAKc/ZvviMkiIX72ju7C5eM5oJcmD+BDJgZrKSm/eGuB6SKtgKFVx6UdoTRDmKzM O3TFBZ0hXgFiMhB6SyUz2McWqZOgtSpnJWoMMzJzHW61rnb3jAjL4f3DEIt6LCbZ+q3x k3mEg8ooCoY/OzM2K1/LPb3z95i7GqiuwEX0qG0ZuB7vzpZ9T0Sm+1ZuRi3cnOnIfvDh TDPQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1726714803; x=1727319603; h=content-transfer-encoding:in-reply-to:references:cc:to:from :content-language:subject:user-agent:mime-version:date:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=1804u5LFTDn9Fw2OOJVq8y75LWua8ousONYhS9QwGmo=; b=YCQDbN22vS9mpKE9wmEW0l5JyzOfXwccx0gSnJK17dSYoK5TKQGoa29WsPZs+lfPBQ pQ9IbjsgRORSC8LbFUvKbOrZ/YSTjChZw5VCK/j1Z4I5tgs3vYRhFi1Q8Kdh5qN2JAPb KQcaEyQGPjF0gQTBmOjZ97Mzr3qG3CTS2DZZKDu/33LrWNjD7Uh7GyFFGByDsXtn7NVW WdeGbc6jTcgkZGv0USirqQrnHk61sr52FIUhXPylGC4AVww4Z/qFJIPawu0m6cJWkVl8 o+iu13JAnrRXqOcVOr9I2IrFL6H5IwApXCWn+Rx8fJEx4YDbNIwjWqnUMLkkyqFrh0uR FVWQ== X-Gm-Message-State: AOJu0YwcJfX5xgxhMw3wfu4iNRcMhGKo7LWhe792Lucz93A6sBRz5tr+ f9r9yxIa+kUK40hNMtWYpiwZ1i6iRd3zU+S1X3klxQT2WBepQc+i X-Google-Smtp-Source: AGHT+IG85dMcgehKdGXbcvlaqvJ2zmzxr1NyhOE8upNg+ANmW65fRrIoRvq8+CqT+h0CMG0d0vG2aA== X-Received: by 2002:a2e:6112:0:b0:2ef:185d:e3d7 with SMTP id 38308e7fff4ca-2f787f3345cmr96867191fa.38.1726714802800; Wed, 18 Sep 2024 20:00:02 -0700 (PDT) Received: from [1.0.0.7] ([178.155.24.71]) by smtp.gmail.com with ESMTPSA id 38308e7fff4ca-2f79d486a4dsm14757161fa.121.2024.09.18.20.00.01 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Wed, 18 Sep 2024 20:00:01 -0700 (PDT) Message-ID: Date: Thu, 19 Sep 2024 06:00:00 +0300 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.4.2 Subject: Re: Should rolpassword be toastable? Content-Language: en-US From: Alexander Lakhin To: Tom Lane , Nathan Bossart Cc: pgsql-hackers References: <89e8649c-eb74-db25-7945-6d6b23992394@gmail.com> <1284094.1695479962@sss.pgh.pa.us> <67793ae1-3adc-a6e0-0bb3-c23a28c0627a@gmail.com> In-Reply-To: <67793ae1-3adc-a6e0-0bb3-c23a28c0627a@gmail.com> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hello Tom and Nathan, 23.09.2023 21:00, Alexander Lakhin wrote: > 23.09.2023 17:39, Tom Lane wrote: >> I'm also now more than just slightly skeptical about whether >> pg_database should have a toast table.  Has anybody tried, >> say, storing a daticurules field wide enough to end up >> out-of-line? > > So for now only pg_authid is worthy of condemnation, AFAICS. > Let me remind you of this issue in light of b52c4fc3c. Yes, it's opposite, but maybe it makes sense to fix it now in the hope that ~1 year of testing will bring something helpful for both changes. Best regards, Alexander