Thanks a lot!

You sir are a HERO.

yes.... nice presentation rellay useful

Interesting personal historical experience

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.

does a transaction lock the table/entity the whole time until the transaction is committed?

Just came here to thank the goat

Late to the party, thanks for sharing Sam!

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

Who’s here after the xz exploit catch?

7 years later he discover xz backdoor, what a guy

Good job Grant!!

Not able to get the values through the same logic dblink Can anyone please guide

I believe large in clauses are now much better optimised.

Thanks, I learned a lot from this!

really gets into the details.

Isn't hash-based partitioning pretty flexible based on the hash function?

Why were triggers and rules not usable and is the mechanism used by partitioning generalizable so that extension authors could implement similar functionality?

Is ALTER EXTENSION transactional?

very nice

I didn't get any clear "do this" from this.

This guy is a gem, love all his work in the Ruby community.

Excellent talk!

🤣😂🤣🤣🤣🤣🤣

old but gold 🙂

starts at 6:08

At last! A presentation I can watch not on x1.25 speed!

This, ladies and gents, is not how you prepare a slide!

We need more Joe celko on KZfaq

Watched this talk after searching for videos on MVCC. I found it properly helpful and well put together

A nice explanation, thank you very much!

Thanks. It was very helpful

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.

This is pretty crazy stuff. I love the idea... I just don't want to be stuck writing SQL for an entire architecture lol

great talk

Quite sure MS-SQL allows that. It is derived from SYBASE which allows cross db queries. Miss that in postges

Good stuff

Great!

45:40 isn't it 8 day avergae?

really insightful stuff

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?

It is so much informative.

That's not 4 million that's 4 Billion

Informative..

by far the best talk I listened so far about Postgres

... 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)

any chance this demo and environment setup is available in git ?

I mean.... meh! 🤷🏻‍♂️

How do you deal with differences in data types from different RDBMS vendors?

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.