Identifying "cold" data

From: Joseph Hammerman <joe(dot)hammerman(at)datadoghq(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Identifying "cold" data
Date: 2022-02-24 18:37:12
Message-ID: CAHs7QM87xwc=h6+p-WpBEvbbJKF8wp2a7NgP-0Qv3W-bgbRhnw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Marcia Rocha 2022-02-24 22:48:49 Re: postgresql14-contrib does not install with libpython 3.7
Previous Message Tom Lane 2022-02-24 15:35:52 Re: postgresql14-contrib does not install with libpython 3.7