In today's 5mins of Postgres, we discuss the streaming I/O changes recently committed to Postgres 17 by Thomas Munro. These represent an important building block for async I/O in future releases, and already improve speed for Sequential Scans & ANALYZE now: pganalyze.com/blog/5mins-pos…

In today's 5mins of Postgres we take a look at the recent B-Tree Index Scan improvements committed to Postgres 17 by Peter Geoghegan together with Matthias van de Meent. If you're using IN lists or ANY= in Postgres, this will likely make your queries faster: pganalyze.com/blog/5mins-pos…

In today's 5mins of Postgres episode we look at the new pg_buffercache_evict function recently committed to Postgres 17 by Thomas Munro, intended for testing cache behavior. You can also test cold cache performance by combining it with POSIX_FADV_DONTNEED: pganalyze.com/blog/5mins-pos…

In today's 5mins of Postgres episode, we take a look at faster VACUUM performance in Postgres 17, thanks to work by Masahiko Sawada & John Naylor. For autovacuum after a full table update, this saved 20% in time, and 50% in memory for dead tuple storage! pganalyze.com/blog/5mins-pos…

Learn about “Automating Postgres Index Selection Using Constraint Programming” with Lukas Fittl at PgDay Chicago 2024!

buff.ly/3IdJVlV

Lukas Fittl PostgreSQL #postgres #conference

Lukas Fittl and team have been doing great work on pganalyze for many years. Happy to make all it's goodness available for Tembo Cloud customers.

On your instance, go to apps, select pganalyze, put in your key and get performance insights.

Excited to launch support for pganalyze on Tembo Cloud! Your instances can now benefit from intelligent tuning advisors and continuous database profiling by enabling the pganalyze app. Read more here: tembo.io/blog/pganalyze

Enjoyed this one with Lukas Fittl Charity Majors and the crew. Yes, databases are really cool.

ORM usage w/o solid fundamentals of SQL, queries, and indexes - works, but only up to a point. Visibility/tracing could be better.

bit.ly/3RLoAGf

In today's 5mins of Postgres, we talk about improved display of SubPlan nodes in EXPLAIN, recently committed to the Postgres 17 development branch: hubs.li/Q02rdJPF0

Learn about “Automating Postgres Index Selection Using Constraint Programming” with Lukas Fittl at PgDay Chicago 2024!

buff.ly/3IdJVlV

Lukas Fittl PostgreSQL #postgres #conference

In today's 5mins of Postgres, we feature @Figma's new blog post from earlier in the week, where they describe how they scaled out their Postgres database through horizontal sharding: hubs.li/Q02pGwcS0

🎧 Podcast release! Postgres in containers? Yep! Lukas Fittl of @pqanalyze joined Nirmal Mehta and me to breakdown all the do's and don'ts of PSQL in containers. We cover some very useful info. Enjoy!
buff.ly/3PernpE
#postgres #postgres ql #DevOps

In this week's 5mins of Postgres episode, we take a look at the recently committed SLRU cache improvements in Postgres 17.

This will make a big difference for large-scale Postgres deployments. Excellent work by Andrey Borodin, Dilip Kumar and Álvaro 🌳 Herrera!

pganalyze.com/blog/5mins-pos…

Today we're excited to introduce pganalyze Index Advisor 3.0 for finding indexing opportunities in Postgres!

This new release uses different configs depending on a table's workload, and the underlying model can be customized as well. Learn more: pganalyze.com/blog/index-adv…

Is your Postgres COUNT(*) too slow? And are you mainly trying to show whether there is a certain amount of items, but if its more than 100, you are okay to say '100+'?

You can speed up these queries significantly by using a LIMIT in a subquery instead: pganalyze.com/blog/5mins-pos…

Fantastic session from Bret Fisher with Lukas Fittl Postgres in Containers - Why (not)? (Ep 254) youtube.com/live/_tQ1fdI6M…

In today's 5mins of Postgres, we talk about how the Postgres planner handles out of range statistics, and when it looks at indexes during planning via the get_actual_variable_range function. We feature Franck Pachot & Mark Callaghan - Full episode here: hubs.li/Q02lg5S80

Hot off the press—just in time for #pgconfeu —new #PathToCitusCon podcast 🎙️ for developers who love #PostgreSQL with a-ma-zing guests Lukas Fittl & The Tortured Postgres Department!

Good weekend listening 🎧 about: My Journey into Postgres Monitoring 📈

Don't you love it? pathtocituscon.transistor.fm/episodes/my-jo…