Hmmm. Two PSQL tables, A and B. B small. Updating A takes days, involves reading B. Seem unable to alter B while A updating. Correct?
-
-
Got it. Updating A puts AccessShare lock on B ALTER TABLE B requires AccessExclusive lock https://www.postgresql.org/docs/9.1/static/explicit-locking.html … h/t
@legalinspire -
ffffffffuuuuuuuu broke after 80+ hours time to rewrite I guesspic.twitter.com/kmihAkLJbP
- Show replies
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.