Re: column max length / max timestamps from system tables

From: sbob <sbob(at)quadratum-braccas(dot)com>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: column max length / max timestamps from system tables
Date: 2021-06-02 19:18:24
Message-ID: 3cf4cc46-c017-a279-dec0-c68a99836bb2@quadratum-braccas.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(at)quadratum-braccas(dot)com
> <mailto:sbob(at)quadratum-braccas(dot)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.
>
>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message dave 2021-06-02 20:00:53 RE: column max length / max timestamps from system tables
Previous Message David G. Johnston 2021-06-02 17:13:19 Re: column max length / max timestamps from system tables