| From: | Peter Geoghegan <pg(at)bowt(dot)ie> |
|---|---|
| To: | Torsten Förtsch <tfoertsch123(at)gmail(dot)com> |
| Cc: | PostgreSQL mailing lists <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: |
| Date: | 2018-07-19 20:05:39 |
| Message-ID: | CAH2-WzmyPtswccGYrY4dMDF0H52XpPF1MMSULEftX74w9TtLhg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Jul 19, 2018 at 11:43 AM, Torsten Förtsch
<tfoertsch123(at)gmail(dot)com> wrote:
> is there a way to find if a certain page in a data file is referenced by a
> btree index?
>
> I found a few completely empty pages in one of my tables. I am not sure if
> that's corruption or just bloat. Now I am thinking I could use an index, the
> PK for instance, and see if it references these pages.
Ir'a probably not serious, but you may want to try amcheck's
heapallindexed check. You'll have to use the non-contrib packages for
that right now, though, but those are available from the PGDG repos.
--
Peter Geoghegan
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tim Cross | 2018-07-19 22:03:22 | Re: User documentation vs Official Docs |
| Previous Message | Torsten Förtsch | 2018-07-19 18:43:38 |