Postgres Pro
Downloads
Home   >   mailing lists

Re: Table health - Mailing list pgsql-admin

From Tomek
Subject Re: Table health
Date
Msg-id CACUaW3SqAmG4bcjAGPcrOK2T8UsSN3Cd3nEgYd++vN7OqvFzMw@mail.gmail.com
Whole thread Raw
In response to Table health  (Rajesh Kumar <rajeshkumar.dba09@gmail.com>)
Responses Re: Table health
List pgsql-admin
Tree view
As a preliminary and often but good enough test, I recommend VACUUM FREEZE VERBOSE ...
In 95% of cases such simple check will satisfy your needs .
Of course amcheck tool is much better but it is an extension. 

wt., 17 paź 2023 o 19:59 Rajesh Kumar <rajeshkumar.dba09@gmail.com> napisał(a):
I have been asked to check table health of specific big table.

What are list of things I have to check?


--

pgsql-admin by date:

Previous
From: Zhaoxun Yan
Date:
Subject: Fwd: postgresql lost connection to repmgr arbitrarily
Next
From: Rajesh Kumar
Date:
Subject: Re: Table health