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 1loWO0-0004be-9b for pgsql-admin@arkaria.postgresql.org; Wed, 02 Jun 2021 19:18:40 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1loWNz-0003nR-53 for pgsql-admin@arkaria.postgresql.org; Wed, 02 Jun 2021 19:18:39 +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 1loWNy-0003nH-6a for pgsql-admin@lists.postgresql.org; Wed, 02 Jun 2021 19:18:38 +0000 Received: from wout5-smtp.messagingengine.com ([64.147.123.21]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1loWNp-0002vi-AK for pgsql-admin@lists.postgresql.org; Wed, 02 Jun 2021 19:18:37 +0000 Received: from compute3.internal (compute3.nyi.internal [10.202.2.43]) by mailout.west.internal (Postfix) with ESMTP id 951C4E95; Wed, 2 Jun 2021 15:18:26 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute3.internal (MEProxy); Wed, 02 Jun 2021 15:18:26 -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; s=fm2; bh=sJ575B5G+HjVvsJpatVQr14c0RfzlHNO+FRvNkT1UrQ=; b=hyMXDq6TfntH MYBI89P8xwcLYUqkhYmFzO45HReO1g05av7p7AsPGhx/ER6PunSwKZaNndZRoTgQ Ay1VMjtBzfh3I1YSxCiialXUkjPwq94H+AcYWSMnIkYnQvbwZMhVspFY4qAepEEo K9Ys9JO8fmGRVzHYmDV08ShOl0EKBTpGMPj2Bhws3CWWkQ0wlQSyKVKGVL3uHbEk /4yHwJAp7t14stDbZxqc3ple6PU3SdEBGejVt0v1tZotjRQCX/8PfI4TQX9x0Ygk wSm8L3sLkwnKfQwcxtP/QGvTR3KuMaPzFrqBpkA59EoLNnV1B6X7A3lu+vW/X86X Xbg4rAAUCg== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc: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=sJ575B 5G+HjVvsJpatVQr14c0RfzlHNO+FRvNkT1UrQ=; b=DHG8E30cOLWlQ7pN2aBQES tPl9BzW/ZywL4iLcQIeTFjGBB7Abl40S+UJmt+FnfsViI4rduEn7qRzPrsiXrTjc ChXQLBuBxz97e+R4P6ZbOI7VBMkdK/aLeVGmSOzY75a75s8lIuEWgfY3KnNeSHEM +6AVtD1AfV+ufB0OLF0BshywfUqjnj2fR2x/L9Du95pWpJwqF51S3GNINNH/rKsq dUo94f1FBZwvT3wXJtK9Opt+JtVAIAiufEhAJN3DioTd5Dkv2IH/SPI2cLzHrRUZ Wyd4u2ftHTVT2e6PlrlHO+5AnZcrCmYSaD6s3t1Cw3aUrCWYHQxofVv4xv3Xhpwg == X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeduledrvdeljedgudefhecutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfgh necuuegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmd enucfjughrpefuvfhfhffkffgfgggjtgesrgdtreertdefjeenucfhrhhomhepshgsohgs uceoshgsohgssehquhgrughrrghtuhhmqdgsrhgrtggtrghsrdgtohhmqeenucggtffrrg htthgvrhhnpeduffetgeejgeeivdetieegteekteegueekvedulefhkeekgffhhfekvdef tedufeenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpe hssghosgesqhhurggurhgrthhumhdqsghrrggttggrshdrtghomh X-ME-Proxy: Received: by mail.messagingengine.com (Postfix) with ESMTPA; Wed, 2 Jun 2021 15:18:25 -0400 (EDT) Subject: Re: column max length / max timestamps from system tables To: "David G. Johnston" Cc: Pgsql-admin References: From: sbob Message-ID: <3cf4cc46-c017-a279-dec0-c68a99836bb2@quadratum-braccas.com> Date: Wed, 2 Jun 2021 13:18:24 -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: Content-Type: multipart/alternative; boundary="------------DC597F4D5E3E3EF30A25FD3A" Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------DC597F4D5E3E3EF30A25FD3A Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit Unfortunately this takes hours since the table has > 500million rows just wanted to see if there was a shorrtcut / alternate On 6/2/21 11:13 AM, David G. Johnston wrote: > > On Wed, Jun 2, 2021, 10:05 sbob > wrote: > > Hi all; > > > we need to pull the max timestamp for a set of columns and the max > string length for another set of columns. Can I get this from system > tables? If so, how up to date would it be? > > > No.  Just query the table directly. > > David J. > > --------------DC597F4D5E3E3EF30A25FD3A Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 8bit

Unfortunately this takes hours since the table has > 500million rows

just wanted to see if there was a shorrtcut / alternate


On 6/2/21 11:13 AM, David G. Johnston wrote:

On Wed, Jun 2, 2021, 10:05 sbob <sbob@quadratum-braccas.com> wrote:
Hi all;


we need to pull the max timestamp for a set of columns and the max
string length for another set of columns. Can I get this from system
tables? If so, how up to date would it be?

No.  Just query the table directly.

David J.


--------------DC597F4D5E3E3EF30A25FD3A--