วีดีโอ

Do you think postgresql/postgis and probably citus cluster will be ok for service like zillow or i should choose scylladb? Thanks

Great video!

thx for links to source ❤

Thanks man, caught deadlock, split transactions, sped up query.

Does enabling auto_explain make a negative impact on the postgres engine? For example, any increase in log generation adversely affecting the CPU and I/O for application queries?

Thank you for video. In some places your sound is a little bit broken

love it!

great talk!

Thanks !!!

guessable keys should not be a threat. regardless of guessable or not, the backend should have authorization logic that prevents unauthorized data access.

Thanks Lukas. I've only really thought about cardinality when using a time series DB. Great info

What a great overview about a topic anyone with an App running PostgreSQL will want to knkow about. Thank you ! I think our ERP is now around 750 tables, on Webforms, and thousands of stored procs.

Chonky! Makes me excited for the upgrade

Thanks, nice preview of new changes and features:)

Just discovered your channel and I've been binge-watching all your videos haha. Great stuff

How do I also record the user who made the change? pgaudit

Thank you for this lesson! I've set random_page_cost wich dropped seq scan on one of our heavy query. This led to significant drop in CPU utilisation. I wonder if you can add somehow this suggestion into pganalyze

Check Citus which powers Azure Cosmos DB.

Oh wow the WHEN NOT MATCHED BY SOURCE was exactly what I needed lol, thank you to whoever implemented it!

Thanks. You channel name is "pganalyze". Does it mean the pganalyze utility, right? But it is not free. But, at least, you make the good videos, so the commercial company made something good.

This is top-notch Postgres content. Thanks for presenting it!

great info, is still inside the 17 release?

Thanks, great content as always

Hello. I guess 25% was recommended as starting point, because it is better when default value. And, of course here may not be enough memory for another processes. As a result, the 45-50% is a finish.

thanks for sharing

What is CTE?

Damn, that's a great explanation in 5 mins. You rocked it Lukas

That's a booby trap if I've ever seen one. Luckily the fix seems pretty easy!

What are the demerits of setting random_page_cost as low as 1.1 If there are some queries on my db , that get benefited from lower the random page cost, is there any other queries that would get hampered due to this?

@pganalyze, can the same prepared transaction be utilized across multiple connections in postgres?

Interesting! Thank You!

Would prepared transactions be no benefit in oltp wirkloads where Assuming that each client will only be executing single block of transactions as opposed to executing multiple blocks of transactions?

You did great thing there. Thanks for great content, as always!

Currently spending the next 6 weekends purging data from a large complex 3nf database with UUID FKs between all of the tables. On an extremely large instance(192G Ram, 48 vCPUs) I'm getting <31 deletes/sec with all the ugly UUID FK lookups.

Never heard about that +0 solution. Genious!!!! Thanks for sharing it.

Woo hoo. Nice job to everyone involved on this as well, including you Lukas for helping raise awareness of this and connect everything together. In Active Record Rails apps, I’ve seen problematic IN clauses with a large amount of values, showing up in PGSS. My feeling is this is going to help a lot when this becomes available.

very effective 5 minutes -- thanks for the great vid!

I am very glad to have found this channel! Got some performance concerns when working with a correlated subquery and this was very enlightening! Thanks

Awesome!

Nice boost. Vacuum can never be fast enough ❤

Thanks for doing these Lukas! I really appreciate your summaries of the features/functionality in commit logs

This is a gem!

Great video, very well explained!

Very interesting! Curious does the unpartitioned table has an index on the partition by column? If not, is the join by index better than partition-wise join

Thanks, Lukas! Very interesting overview, I was not aware of many details. BTW there will be a talk on this topic by Dilip at PGConf this year. Looking forward to it.

Thanks Lucas ❤

Nice examples Lukas showing the SQL to set up ranges using the new functions.

Thanks Lukas! For this kind of excellent, but densely filled blog post, on high value planner optimizations with example queries that benefit, I appreciate having this overview of the items to start to digest them. It's easier to slot the quick audio into my day, then I can go back into the nitty gritty details of the post and try the examples out. Thanks to David, Melanie, and all the contributors for these improvements!

Congratulations on 100th episode Lukas!