> 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.
ok into this, seems helpful. Thanks!
On Wed, Jul 17, 2019 at 12:21 PM Peter Geoghegan wrote:
> On Wed, Jul 17, 2019 at 8:54 AM Aaron Pelz wrote:
> > To me it looks like a *single* corrupt index held up autovacuums across
> our entire server, even other in other databases on the same s
Hello,
Over the weekend we noticed that our max transaction IDs have been
continuously increasing - got an alert it passed 1B - and we believe that
no autovacuums were running for a period of about a month by looking at
pg_stat_user_tables. We had not updated any autovac tuning parameters over
tha
