Amcheck extension query for tables (verify_heapam)

From: Raul Kaubi <raulkaubi(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Amcheck extension query for tables (verify_heapam)
Date: 2022-05-30 08:00:02
Message-ID: CAO_+3-DVEzqoMt+4K=MYpvEB0uTPo3y9eN369YmOfBGeqQyMEg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Laurenz Albe 2022-05-30 11:23:51 Re: how to calibrate the cost model parameters
Previous Message jian xu 2022-05-29 15:29:55 how to calibrate the cost model parameters