вт, 3 мар. 2020 г. в 01:03, Peter Geoghegan <pg(at)bowt(dot)ie>:
> I think it's more likely that the problem here is the relatively new
> column returned by bt_metap(), oldest_xact. That has only been around
> since Postgres v11.
>
This made me look at the stats, as this is a test copy of the DB upgraded
to 12.2 recently. Per pg_stat_user_tables,
table had never been vacuumed since upgrade, only analyzed.
I've run vacuum manually and this made the issue go away.
It is beyond my skills to try to find the real place for this issue now. I
think we might be hitting some uninitialized value somewhere, perhaps?..
--
Victor Yegorov