From: Torsten Förtsch <tfoertsch123(at)gmail(dot)com>
To: PostgreSQL mailing lists <pgsql-general(at)postgresql(dot)org>
Subject:
Date: 2018-07-19 18:43:38
Message-ID: CAKkG4_ms9uLr=8NwPZeRWSZcqVnURTjTXkSqzX=-ZNHObEL0qQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

  • Re: at 2018-07-19 20:05:39 from Peter Geoghegan

Browse pgsql-general by date

  From Date Subject
Next Message Peter Geoghegan 2018-07-19 20:05:39 Re:
Previous Message Torsten Förtsch 2018-07-19 18:35:33 Re: functions with side effect