SELECT verify_heapam('mytable')
Raul Kaubi wrote on 5/30/2022 4:00 AM:
> Hi
>
> PostgreSQL 14 has the built in function for amcheck extension called
> "verify_heapam".
> I was wondering, is there similar query for that function as well like
> there is for "bt_index_check" function..?
>
> I do not see that here:
> https://www.postgresql.org/docs/14/amcheck.html
>
> I would like to monitor both (tables and indexes) for corruption checks.
>
> Regards
> Raul Kaubi
Regards,
Michael Vitale
Michaeldba(at)sqlexec(dot)com <mailto:michaelvitale(at)sqlexec(dot)com>
703-600-9343