> Can you tell us more about this index? Can you share its definition > (i.e. what does \d show in psql)?
> Is it an expression index, or a partial index? A composite? What > datatypes are indexed? It's a simple btree expression on a geometry(Point,4326) , no expression no partial no composite. On Wed, Jul 17, 2019 at 3:58 PM Peter Geoghegan <p...@bowt.ie> wrote: > On Wed, Jul 17, 2019 at 10:27 AM Peter Geoghegan <p...@bowt.ie> wrote: > > > It's possible that amcheck would have given you an accurate diagnosis > > > of the problem -- especially if you used bt_index_parent_check(): > > > > > > https://www.postgresql.org/docs/current/amcheck.html > > > > BTW, be sure to use the 'heapallindexed' option with > > bt_index_parent_check() to detect missing downlinks, which is exactly > > the problem that VACUUM complained about. > > Can you tell us more about this index? Can you share its definition > (i.e. what does \d show in psql)? > > Is it an expression index, or a partial index? A composite? What > datatypes are indexed? > > Thanks > -- > Peter Geoghegan >
