pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Bruce Momjian <bruce@momjian.us>
To: sbob <sbob@quadratum-braccas.com>
Cc: Scott Ribe <scott_ribe@elevated-dev.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: column max length / max timestamps from system tables
Date: Wed, 2 Jun 2021 17:43:54 -0400
Message-ID: <20210602214354.GA22019@momjian.us> (raw)
In-Reply-To: <c0575f15-3291-671f-8679-92995caea7da@quadratum-braccas.com>
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>
	<c0575f15-3291-671f-8679-92995caea7da@quadratum-braccas.com>

On Wed, Jun  2, 2021 at 03:33:32PM -0600, sbob wrote:
> Good point... I'll try this

You could technically try to look at the pg_statistics values, but those
are only populated by random page sampling, and only current as of the
last analyze or autovacuum auto-analyze.

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  If only the physical world exists, free will is an illusion.






view thread (9+ messages)  latest in thread

Message-ID: <20210602214354.GA22019@momjian.us>
Permalink:  ../20210602214354.GA22019@momjian.us/
Also on:    postgresql.org/message-id/20210602214354.GA22019@momjian.us

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: bruce@momjian.us, sbob@quadratum-braccas.com, scott_ribe@elevated-dev.com, pgsql-admin@lists.postgresql.org
  Subject: Re: column max length / max timestamps from system tables
  In-Reply-To: <20210602214354.GA22019@momjian.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox