| From: | Peter Geoghegan <pg(at)bowt(dot)ie> |
|---|---|
| To: | Mark Dilger <mark(dot)dilger(at)enterprisedb(dot)com> |
| Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Robert Haas <robert(dot)haas(at)enterprisedb(dot)com> |
| Subject: | Re: new heapcheck contrib module |
| Date: | 2020-04-20 18:09:20 |
| Message-ID: | CAH2-Wzk82qUGqSF8Cu=_CBfarYEBHJTBLzVRzDB1kBCt2vA0vg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Mon, Apr 20, 2020 at 10:59 AM Mark Dilger
<mark(dot)dilger(at)enterprisedb(dot)com> wrote:
> The attached module provides the means to scan a relation and sanity check it. Currently, it checks xmin and xmax values against relfrozenxid and relminmxid, and also validates TOAST pointers. If people like this, it could be expanded to perform additional checks.
Cool. Why not make it part of contrib/amcheck?
We talked about the kinds of checks that we'd like to have for a tool
like this before:
https://postgr.es/m/20161017014605.GA1220186@tornado.leadboat.com
--
Peter Geoghegan
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2020-04-20 18:19:43 | Re: new heapcheck contrib module |
| Previous Message | Robert Haas | 2020-04-20 18:09:06 | Re: design for parallel backup |