No title

Started by Torsten Förtschalmost 8 years ago2 messagesgeneral

tfoertsch123@gmail.com

almost 8 years ago

Hi,

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.

Thanks,
Torsten

Peter Geoghegan

pg@bowt.ie

almost 8 years ago

In reply to: Torsten Förtsch (#1)

Re:

On Thu, Jul 19, 2018 at 11:43 AM, Torsten Förtsch
<tfoertsch123@gmail.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