Hi, On 2018-06-19 17:05:48 -0300, Matheus de Oliveira wrote: > > You should first make sure it's actually this problem - which tables are > > holding back the xmin horizon? > > > How can I be sure? The tables are `pg_authid` and `pg_auth_members`, the > following message is logged every minute (which I belive is due to > `autovacuum_naptime`, which is using the default of 1 minute):
Yes, that sounds like the issue. Basically just wanted the table names: > ERROR: found xmin 3460221635 from before relfrozenxid 1245633870 > CONTEXT: automatic vacuum of table "template0.pg_catalog.pg_authid" which indeed are shared relations. Greetings, Andres Freund
