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?
-
-
Replying to @eigenrobot
fortunately can still read B, so just copying to a temp table and altering that, will rename later good enough
1 reply 0 retweets 2 likes -
Replying to @eigenrobot
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
@legalinspire1 reply 0 retweets 3 likes -
Replying to @eigenrobot @legalinspire
ffffffffuuuuuuuu broke after 80+ hours time to rewrite I guesspic.twitter.com/kmihAkLJbP
1 reply 0 retweets 2 likes -
-
-
Replying to @legalinspire
Yeah probably going to do step by step. Later tho gotta have some base results for Monday
1 reply 0 retweets 1 like -
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.
