Re: Table health

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxx> 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@xxxxxxxxx> napisał(a):
I have been asked to check table health of specific big table.

What are list of things I have to check?


--

[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux