| From: | Peter Geoghegan <pg(at)bowt(dot)ie> |
|---|---|
| To: | Jeremy Finzel <finzelj(at)gmail(dot)com> |
| Cc: | Andres Freund <andres(at)anarazel(dot)de>, Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, Postgres General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: found xmin from before relfrozenxid on pg_catalog.pg_authid |
| Date: | 2018-03-22 20:20:24 |
| Message-ID: | CAH2-WznjoRqEHcBvDeSyV=wmtw6rx3zAyg60ggj02Rg31FJF-g@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
On Thu, Mar 22, 2018 at 12:27 PM, Jeremy Finzel <finzelj(at)gmail(dot)com> wrote:
> Thank you for the recommendation. I ran both amcheck functions on all 4
> indexes of those 2 tables with heapallindexed = true, but no issues were
> found.
Probably wouldn't hurt to run it against all indexes, if you can make
time for that. If you can generalize from the example query that calls
the bt_index_check() function, but set
"heapallindexed=>i.indisprimary" and remove "n.nspname =
'pg_catalog'", as well as "LIMIT 10". This will test tables and
indexes from all schemas, which might be interesting.
--
Peter Geoghegan
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeremy Finzel | 2018-03-22 21:24:13 | Re: found xmin from before relfrozenxid on pg_catalog.pg_authid |
| Previous Message | Alvaro Herrera | 2018-03-22 19:40:04 | Re: found xmin from before relfrozenxid on pg_catalog.pg_authid |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2018-03-22 20:23:57 | Re: Re: Re: reorganizing partitioning code |
| Previous Message | Robert Haas | 2018-03-22 20:19:11 | Re: parallel append vs. simple UNION ALL |