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
