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
Does updating A require dynamic access to B or read once at start?
2 replies 0 retweets 1 like -
Replying to @legalinspire
unsure, I imagine it's read-once (included in an early WITH subquery) but who knows how optimizer plays out
1 reply 0 retweets 1 like -
Replying to @eigenrobot
Maybe dump B into a cursor or something and use it instead if you need B to be writable during? Problems are obvious...
1 reply 0 retweets 1 like -
Replying to @legalinspire @eigenrobot
...but sometimes brute force isn't bad. :)
1 reply 0 retweets 1 like -
Replying to @legalinspire @eigenrobot
BTW I am not trying to teach you anything. Your level of knowledge is so far above mine the light from it will not reach me for years.
1 reply 0 retweets 1 like -
Replying to @legalinspire @eigenrobot
But as the saying goes, the greatest swordsman fears not the second-greatest, but the worst. :)
1 reply 0 retweets 1 like
Replying to @legalinspire
oh god no I'm garbage at sql :)
7:59 AM - 28 Jul 2017
0 replies
0 retweets
0 likes
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.