3 ms·
> There was a long-running transaction, usually relating to PostgreSQL's autovacuuming, during the time. The stalls stopped quickly after the transaction ended.
by lixtra 5y ago
> There was a long-running transaction, usually relating to PostgreSQL's autovacuuming, during the time. The stalls stopped quickly after the transaction ended.
What is about the other end?
Why does vacuum need to be a long running transaction and cannot be cut into shorter transactions ?
- funny_falcon 5y agoVacuum is just "most common" long transaction. Take reports: some of them take hours to build.