pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedAmcheck extension query for tables (verify_heapam)
3+ messages / 3 participants
[nested] [flat]
* Amcheck extension query for tables (verify_heapam)
@ 2022-05-30 08:00 Raul Kaubi <raulkaubi@gmail.com>
0 siblings, 2 replies; 3+ messages in thread
From: Raul Kaubi @ 2022-05-30 08:00 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Amcheck extension query for tables (verify_heapam)
@ 2022-05-30 13:33 MichaelDBA <MichaelDBA@sqlexec.com>
parent: Raul Kaubi <raulkaubi@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: MichaelDBA @ 2022-05-30 13:33 UTC (permalink / raw)
To: Raul Kaubi <raulkaubi@gmail.com>; +Cc: 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@sqlexec.com <mailto:michaelvitale@sqlexec.com>
703-600-9343
Attachments:
pgadvanced3.jpg (image/jpeg, 20.6K) download
view image
* Re: Amcheck extension query for tables (verify_heapam)
@ 2022-05-30 15:36 Peter Geoghegan <pg@bowt.ie>
parent: Raul Kaubi <raulkaubi@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Peter Geoghegan @ 2022-05-30 15:36 UTC (permalink / raw)
To: Raul Kaubi <raulkaubi@gmail.com>; +Cc: pgsql-admin
On Mon, May 30, 2022 at 1:00 AM Raul Kaubi <raulkaubi@gmail.com> wrote:
> 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..?
You should probably just use the higher level pg_amcheck utility,
which runs everything from amcheck including verify_heapam() under the
hood.
--
Peter Geoghegan
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2022-05-30 15:36 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2022-05-30 08:00 Amcheck extension query for tables (verify_heapam) Raul Kaubi <raulkaubi@gmail.com>
2022-05-30 13:33 ` MichaelDBA <MichaelDBA@sqlexec.com>
2022-05-30 15:36 ` Peter Geoghegan <pg@bowt.ie>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox