Postgres Pro
Downloads
Home   >   mailing lists

Re: Amcheck extension query for tables (verify_heapam) - Mailing list pgsql-admin

From MichaelDBA
Subject Re: Amcheck extension query for tables (verify_heapam)
Date
Msg-id 434a69ab-e8e2-8c2c-815e-dbb15f6abed4@sqlexec.com
Whole thread Raw
In response to Amcheck extension query for tables (verify_heapam)  (Raul Kaubi <raulkaubi@gmail.com>)
List pgsql-admin
Tree view 
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:

I would like to monitor both (tables and indexes) for corruption checks.

Regards
Raul Kaubi


Regards,

Michael Vitale

Michaeldba@sqlexec.com

703-600-9343 


Attachment

pgsql-admin by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: how to calibrate the cost model parameters
Next
From: Peter Geoghegan
Date:
Subject: Re: Amcheck extension query for tables (verify_heapam)