postgresqlvacuumautovacuum

PostgreSQL failed with vacuum and autovacuum


Postgres v11.9

There are many errors on Postgres log like this:

    2020-09-05 17:35:37 GMT [22464]: @: [6-1] ERROR:  uncommitted xmin 636700836 from before xid cutoff 809126794 needs to be frozen
2020-09-05 17:35:37 GMT [22464]: @: [7-1] CONTEXT:  automatic vacuum of table "table_nane"

Manual vacuum fails with this error too.

What can I do to fix this error?


Solution