Very good idea, very badly executed. It would have been more helpful if you stated explicitly why certain things are bad practices so that one doesn't have to read between the lines what you really mean.
@rakeshmali17272 ай бұрын
does a transaction lock the table/entity the whole time until the transaction is committed?
@gokulm35842 ай бұрын
Just came here to thank the goat
@patrickwheeler19792 ай бұрын
Late to the party, thanks for sharing Sam!
@berndeckenfels3 ай бұрын
Mmm.. that’s more like a brief overview than everything you need to know, could do with a list of all init Paramus and their meaning, and especially how to diagnose the various Wal metrics
@egorsozonov74253 ай бұрын
Who’s here after the xz exploit catch?
@ekosetiawan68873 ай бұрын
7 years later he discover xz backdoor, what a guy
@2008topshelf4 ай бұрын
Good job Grant!!
@user-vl8il3gx4c4 ай бұрын
Not able to get the values through the same logic dblink Can anyone please guide
@DylanYoung5 ай бұрын
I believe large in clauses are now much better optimised.
@arcstur6 ай бұрын
Thanks, I learned a lot from this!
@nareshgb16 ай бұрын
really gets into the details.
@DylanYoung7 ай бұрын
Isn't hash-based partitioning pretty flexible based on the hash function?
@DylanYoung7 ай бұрын
Why were triggers and rules not usable and is the mechanism used by partitioning generalizable so that extension authors could implement similar functionality?
@DylanYoung7 ай бұрын
Is ALTER EXTENSION transactional?
@StopSocialismUSA7 ай бұрын
very nice
@MrMikomi8 ай бұрын
I didn't get any clear "do this" from this.
@lionkiddo9 ай бұрын
This guy is a gem, love all his work in the Ruby community.
@DevranUenal6 ай бұрын
he is! His work made my work so much easier!
@SARANSASIDHARAN1 Жыл бұрын
Excellent talk!
@fadidib8516 Жыл бұрын
🤣😂🤣🤣🤣🤣🤣
@nicypp Жыл бұрын
old but gold 🙂
@blasttrash Жыл бұрын
starts at 6:08
@Elfcheg Жыл бұрын
At last! A presentation I can watch not on x1.25 speed!
@andherium Жыл бұрын
This, ladies and gents, is not how you prepare a slide!
@DinHamburg Жыл бұрын
We need more Joe celko on KZbin
@andreistefanie Жыл бұрын
Watched this talk after searching for videos on MVCC. I found it properly helpful and well put together
@mucahityavuz Жыл бұрын
A nice explanation, thank you very much!
@user-fr2fd4vj4p Жыл бұрын
Thanks. It was very helpful
@gr4211 Жыл бұрын
Sierpinsky's triangle wasn't showing up on my PG client DBeaver. It only showed one cell with two stars **. I double clicked on the cell and then it expanded and displayed properly.
@lucrativelepton Жыл бұрын
This is pretty crazy stuff. I love the idea... I just don't want to be stuck writing SQL for an entire architecture lol
@tomsheldonworld Жыл бұрын
great talk
@mahoneg Жыл бұрын
Quite sure MS-SQL allows that. It is derived from SYBASE which allows cross db queries. Miss that in postges
@quaryaband Жыл бұрын
Good stuff
@stefantzeggai7037 Жыл бұрын
Great!
@Adaetro Жыл бұрын
45:40 isn't it 8 day avergae?
@Adaetro Жыл бұрын
really insightful stuff
@565paolo Жыл бұрын
When it gets so late at the fact that he could have simply run EXPLAIN ANALYZE and see what was preventing the query from running faster this talk starts to feel like a troll. How could you not Google anything during this time and realize the existence of it?
@divyachauhan3478 Жыл бұрын
It is so much informative.
@bhushan79902 жыл бұрын
That's not 4 million that's 4 Billion
@BestTechLearn2 жыл бұрын
Informative..
@india_is_greatest2 жыл бұрын
by far the best talk I listened so far about Postgres
@georgelza2 жыл бұрын
... have not finished watching session yet... but damm enjoying it... will be looking at deploying this and seeing it in work... question, are you CRD's capable/AWS EKS multi AZ aware, aka, can I deploy on EKS and point it via nodeselector to the various nodes of the various az's (via say labals)
@georgelza2 жыл бұрын
any chance this demo and environment setup is available in git ?
@dakshgargas10422 жыл бұрын
I mean.... meh! 🤷🏻♂️
@arishtat662 жыл бұрын
How do you deal with differences in data types from different RDBMS vendors?
@Asdayasman2 жыл бұрын
Real good talk, I love the idea of separate users for r, ro, and ddl. Seems like something that would implement really easily with Django and its generic views - ListView and DetailView use the r user, UpdateView and DeleteView use the ro user, etc.