Re: Table health

There is no problem with vaccum, i used to do it periodically...apart from
vaccum i am asking things like table bloat, index bloat, duplicate index
removal, unused index removal, cache hit ratio for table, cache hit ratio
for index, .......what else?

Also, i saw cache hit ratio is only 2% for one big table and all other
tables are around 9%. Is that a problem?

On Wed, 18 Oct, 2023, 6:10 PM Tomek, <tomekphotos(at)gmail(dot)com> wrote:

> 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(dot)dba09(at)gmail(dot)com>
> napisał(a):
>
>> I have been asked to check table health of specific big table.
>>
>> What are list of things I have to check?
>>
>
>
> --
> --
> Polecam moje mojego autorstwa na FB
> <https://www.facebook.com/tomasz.main/photos_albums>
>