Identifying "cold" data - Mailing list pgsql-admin

From Joseph Hammerman
Subject Identifying "cold" data
Date
Msg-id CAHs7QM87xwc=h6+p-WpBEvbbJKF8wp2a7NgP-0Qv3W-bgbRhnw@mail.gmail.com
Whole thread Raw
Responses Re: Identifying "cold" data  (Ron <ronljohnsonjr@gmail.com>)
List pgsql-admin
Hi postgresql-admins,

Has anyone put any thought or effort into figuring out how to measure the total volume of data in a database against how much of it is hot? I'm looking for some automatable approaches. Similarly, is there a way to measure rarely queried columns, or unused functions & triggers?

Thanks in advance for any assistance that anyone can provide,
Joseph Hammerman

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: postgresql14-contrib does not install with libpython 3.7
Next
From: Marcia Rocha
Date:
Subject: Re: postgresql14-contrib does not install with libpython 3.7