From: | Tomek <tomekphotos(at)gmail(dot)com> |
---|---|
To: | Rajesh Kumar <rajeshkumar(dot)dba09(at)gmail(dot)com> |
Cc: | Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Table health |
Date: | 2023-10-18 14:02:13 |
Message-ID: | CACUaW3R+rbLR0oaikRHFpDvafFV5kzoGQCYHbZGxXuFdakc1jA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
OK :-) Now you are more specific.
previously I understood that it was about whether the table was damaged in
some way.
So, :-) if you define how you understand "health of table" you will
automatically get the list you ask about (sorry :-) ).
I think that cache hit is important but should be not on this "check table
health" list.
śr., 18 paź 2023 o 15:37 Rajesh Kumar <rajeshkumar(dot)dba09(at)gmail(dot)com>
napisał(a):
> 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>
>>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Ron | 2023-10-18 14:11:58 | Re: Table health |
Previous Message | Rajesh Kumar | 2023-10-18 13:37:45 | Re: Table health |