Re: Table health
| От | Tomek |
|---|---|
| Тема | Re: Table health |
| Дата | |
| Msg-id | CACUaW3R+rbLR0oaikRHFpDvafFV5kzoGQCYHbZGxXuFdakc1jA@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Table health (Rajesh Kumar <rajeshkumar.dba09@gmail.com>) |
| Список | 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 :-) ).
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.dba09@gmail.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@gmail.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.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 по дате отправления: