regarding bloat and fragmentation, if it's ensured that the long-running tx can access to only the table A, we can safely vacuum table B even while that tx is running? #pgconfasia
FWIW, we already can take into account when transactions are running in other databases (unless we're processing shared tables).
-
-
Ah ok - so vacuum already does this today - only considers open transactions in same database. (
#TIL - thanks andres)Thanks. Twitter will use this to make your timeline better. UndoUndo
-
Loading seems to be taking a while.
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.