Re: Amcheck extension query for tables (verify_heapam)

From: MichaelDBA <MichaelDBA(at)sqlexec(dot)com>
To: Raul Kaubi <raulkaubi(at)gmail(dot)com>
Cc: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Amcheck extension query for tables (verify_heapam)
Date: 2022-05-30 13:33:58
Message-ID: 434a69ab-e8e2-8c2c-815e-dbb15f6abed4@sqlexec.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Peter Geoghegan 2022-05-30 15:36:04 Re: Amcheck extension query for tables (verify_heapam)
Previous Message Laurenz Albe 2022-05-30 11:23:51 Re: how to calibrate the cost model parameters