> 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?
> (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 <pg@xxxxxxx> wrote:
On Wed, Jul 17, 2019 at 10:27 AM Peter Geoghegan <pg@xxxxxxx> 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