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 <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1loYUl-0000z1-Kj
	for pgsql-admin@arkaria.postgresql.org; Wed, 02 Jun 2021 21:33:47 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1loYUj-0004DQ-QL
	for pgsql-admin@arkaria.postgresql.org; Wed, 02 Jun 2021 21:33:45 +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 <sbob@quadratum-braccas.com>)
	id 1loYUi-0004DH-9H
	for pgsql-admin@lists.postgresql.org; Wed, 02 Jun 2021 21:33:45 +0000
Received: from wout2-smtp.messagingengine.com ([64.147.123.25])
	by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <sbob@quadratum-braccas.com>)
	id 1loYUc-00041Z-Ru
	for pgsql-admin@lists.postgresql.org; Wed, 02 Jun 2021 21:33:43 +0000
Received: from compute5.internal (compute5.nyi.internal [10.202.2.45])
	by mailout.west.internal (Postfix) with ESMTP id ED745DAA;
	Wed,  2 Jun 2021 17:33:33 -0400 (EDT)
Received: from mailfrontend1 ([10.202.2.162])
  by compute5.internal (MEProxy); Wed, 02 Jun 2021 17:33:34 -0400
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=
	quadratum-braccas.com; h=subject:to:cc:references:from
	:message-id:date:mime-version:in-reply-to:content-type
	:content-transfer-encoding; s=fm2; bh=jRwlYaisxqjeCMAO9EUIbejexK
	bXVOBoqsDNpbwh/YA=; b=KBKOsvNFzNwcMn7rZyGY6yyOhTG0xNCFu84vwLcpis
	wh7/srlOY3doJzxY/aKamh4AQldL1YtcscYz6k+BcdpT5UZPVyKA59m9pIgVELXp
	Cg2unh2u4BwDNBwSuPKy68ZoGsCawscIfj58FjvE1sUaxs0enj2vZQzhwWsNCHFJ
	62gXDy3v7JKRCEV/3YlGi+RUT++xxOe7sv8YkWhcaGWvO3I7oBT1ErpEljMHDu6B
	t6dvuEk6vyDT+xOfrTMGfi6an03EoEXYeX+maYc/eDejR6i0dySirxerl/AGIgzN
	WHKSAlFY3F/hQITYE493fUTw6vsVUSdn8l7HamxqF+Sg==
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=
	messagingengine.com; h=cc:content-transfer-encoding:content-type
	:date:from:in-reply-to:message-id:mime-version:references
	:subject:to:x-me-proxy:x-me-proxy:x-me-sender:x-me-sender
	:x-sasl-enc; s=fm2; bh=jRwlYaisxqjeCMAO9EUIbejexKbXVOBoqsDNpbwh/
	YA=; b=YLTgCNdbmP0IxEAczUZmDw/5UZRaYfJUuqB8pKPBeRrmU8cjtDjinCRt2
	9g57uztEu7QDLn1PhT6ItX9vYEhrWt0yWFgJTaoNCDxYiiv5Ynn5m/93wUDx0YUk
	3umNBAww64/03Jjvonudka/RoCc4llxwxE6pHLmCt64i1gShXWys15E4N3l+I0ay
	CAGw4w7Lel73gaVQFzGqvcr4SxGaq6w/uASq93786aDxM3Fr7qgD9ryV+BSE8x2K
	uCO9B9OXf5E1IV4qbrWGFdJucuCNmhKQrghAFl3mRTVumWnp59SgEqDd0ExAsTP0
	r6Sc71Mzbup/d5tjGWfoFlfWy5Hqw==
X-ME-Sender: <xms:Lfm3YNdck0OPQI8NvP_NgUKUB2XmLtxJ9-g79oHjs7Js_OjygLhDaQ>
    <xme:Lfm3YLPNUXtHv2jokCZ5IzOpFIwN-ZzBJCFjqjOxX9VnqnWsZAnD-xIiY5gjUB2Ns
    1eYVIaaO4eqMnEnPYo>
X-ME-Received: 
 <xmr:Lfm3YGi_B9O6wysiZF-_kGQAtZ4e94GE6h7T-GoqAbqXnoEZZCHw2IsqALT8hILE3g1URPNDhU4Wq0LbMeTrM-1vmGrXxyMvnz7PXE7812eH70Hv4RE>
X-ME-Proxy-Cause: 
 gggruggvucftvghtrhhoucdtuddrgeduledrvdeljedgudeivdcutefuodetggdotefrod
    ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfgh
    necuuegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmd
    enucfjughrpefuvfhfhffkffgfgggjtgfgsehtkeertddtfeejnecuhfhrohhmpehssgho
    sgcuoehssghosgesqhhurggurhgrthhumhdqsghrrggttggrshdrtghomheqnecuggftrf
    grthhtvghrnhepgfektdeitdeivdevgfetjeektdefveefjeetveeiffekvefhjeelgfel
    udeiveehnecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomh
    epshgsohgssehquhgrughrrghtuhhmqdgsrhgrtggtrghsrdgtohhm
X-ME-Proxy: <xmx:Lfm3YG9bB7lQk32ESKD0mplMME-OsltT9hoF57Pf23mAtvmlWqGNwg>
    <xmx:Lfm3YJts3ywyOXvXwu0WtJ3ZVOAfHyVLq5vaeJ90by4cBa10Tkq9kQ>
    <xmx:Lfm3YFEcf-DSCuULnJ_8-NxApVEW9Unv9FyCnOc_aegEkMQyJmsKcw>
    <xmx:Lfm3YH1hNm4wzILx3bA-7tyUatydgAjRmpzQSaJmxa_vtEozECPGOQ>
Received: by mail.messagingengine.com (Postfix) with ESMTPA; Wed,
 2 Jun 2021 17:33:32 -0400 (EDT)
Subject: Re: column max length / max timestamps from system tables
To: Scott Ribe <scott_ribe@elevated-dev.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
References: <ece3ad60-60fc-fbf2-f790-3739965ae098@quadratum-braccas.com>
 <CAKFQuwZ--+Misi5Li=1658cesYT5e92jR_AcZBEuo7PD8abT6A@mail.gmail.com>
 <3cf4cc46-c017-a279-dec0-c68a99836bb2@quadratum-braccas.com>
 <06f401d757e9$fe3b13c0$fab13b40$@co.uk>
 <8CE52907-2264-43BA-9E90-DDC5F0E28109@elevated-dev.com>
From: sbob <sbob@quadratum-braccas.com>
Message-ID: <c0575f15-3291-671f-8679-92995caea7da@quadratum-braccas.com>
Date: Wed, 2 Jun 2021 15:33:32 -0600
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101
 Thunderbird/78.10.1
MIME-Version: 1.0
In-Reply-To: <8CE52907-2264-43BA-9E90-DDC5F0E28109@elevated-dev.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit
Content-Language: en-US
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Archived-At: 
 <https://www.postgresql.org/message-id/c0575f15-3291-671f-8679-92995caea7da%40quadratum-braccas.com>
Precedence: bulk

Good point... I'll try this


On 6/2/21 2:32 PM, Scott Ribe wrote:
>> On Jun 2, 2021, at 2:00 PM, <dave@davebolt.co.uk> <dave@davebolt.co.uk> wrote:
>>
>> For the other column I’m guessing more work has to be done finding the length for each row. Maybe maintaining a column containing the current length for each row would help?
> or a functional index
>