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)
End of conversation
New conversation -
-
-
Fujii didn't specifically say table B was in the same database as table A... But yeah I know it probably was :)
-
We filter out longrunning transactions on other databases for the purpose of vacuuming. CF GetOldestXmin().
End of conversation
New conversation -
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.