In last week's E114 of "5mins of Postgres" we discussed the security fix (CVE-2024-4317) contained in the recent Postgres minor releases, and how to resolve it on existing systems: hubs.li/Q02wSLMp0

In today's 5mins of Postgres, we discuss bad row estimates on JSONB columns and how to fix them. We feature (Dr.) Eric Fritz's post from earlier this week that used CREATE STATISTICS to improve planner stats, as well as previous posts by Vsevolod Solovyov & Adrien Nayrat: hubs.li/Q02xFZ4-0

In last week's E115 of "5mins of Postgres" we discussed bad query plans caused by incorrect JSONB selectivity estimates, and how to fix them: hubs.li/Q02xF-QY0

In today's 5mins of Postgres, we discuss Postgres 17 beta 1, which was released earlier this week. We also discuss a few of the changes that ended up being reverted since the feature freeze, and explain how to report bugs during beta testing: hubs.li/Q02ysBFy0

In last week's E116 of "5mins of Postgres" we discussed a few highlights of the Postgres 17 beta 1 release, and how to help during the beta testing period: hubs.li/Q02yswJX0

In today's 5mins of Postgres, we discuss JOIN column equivalence and when there are issues with IN/ANY filters not being considered as part of an equivalence class in #Postgres. Featuring a blog post by Deepak Mahto: hubs.li/Q02zbLSc0

In last week's E117 of "5mins of Postgres" we discussed JOIN column equivalence and when there are issues with IN/ANY filters, and how adding an extra WHERE clause helps improve query plans: hubs.li/Q02zbQCy0

In today's 5mins of Postgres, we talk about tuning work_mem, and the surprising facts about how Postgres allocates memory based on it, and hash_mem_multiplier. Featuring a post by Shaun Thomas on the old tembo blog. hubs.ly/Q02C4N6q0

Blog post: We take a look at #ConstraintProgramming in action based on our experience optimizing index selection in #Postgres. We deep dive into what makes Postgres Index Selection difficult and how utilizing a CP model can help: pganalyze.com/blog/index-sel…

Join us Sept. 26 for our live event, "Hands on Postgres 17" to learn how enhancements, like faster B-tree scans, adaptive vacuum strategies, & streaming I/O updates, will impact your database performance & monitoring. Register->bit.ly/postgres17

Check out one of our most popular "5 mins of Postgres" episodes - No. 111 where we discuss faster B-tree index scans in Postgres 17. Watch the full episode here ➡️ lnkd.in/g2_zYCkM Register for next week's webinar, Hands on Postgres 17 ➡️ bit.ly/postgres17

Don't miss your chance to register for this Thursday's webinar, "Hands on Postgres 17" to learn how important updates will impact your database performance & monitoring. Register to join live or get the recording here ➡️ bit.ly/postgres17soci… #Postgresql #Database

Today, we return to our #Postgres Planner Quirks series to discuss Incremental Sort (first added in Postgres 13, and improved in Postgres 16+), and why its costing logic can sometimes produce bad plans. See the full episode here ➡️ pganalyze.com/blog/5mins-pos…

Join us next week to discuss how to compare EXPLAIN plans & tune slow #PostgreSQL queries. What used to a painstaking process in an external SQL editor is now streamlined inside of pganalyze. Register for Wed., Nov 13 here: bit.ly/comparepgplans

Amazon Aurora users: streamline query optimization with new plan statistics in pganalyze. Automatically collect execution plans for every query using aurora_stat_plans—enabled by default. Read the full blog for details: bit.ly/planstatistics #PostgreSQL #AmazonAurora

Introducing Buffer Cache Statistics in pganalyze! Dive into how your #PostgreSQL buffer cache evolves over time, diagnosing query slowdowns and optimizing performance. Read more: hubs.li/Q02-yvdB0

Introducing Query Tuning Workbooks in pganalyze! 🎉 Safely benchmark, experiment, and optimize your Postgres queries on production. pganalyze.com/blog/introduci…