Chris has some tips on helping you get the most out of queries when working with a remote Postgres foreign data wrapper. He has an overview of how queries are executed with the fdw and then samples for using CTEs, sub-queries, materialized views, and more.
We are excited to release version 5.4 of Crunchy Postgres for Kubernetes with support for ARM processors, pgvector, huge pages, Postgres tablespaces, and more.
Skewed or uneven data is common in Postgres. Elizabeth has a quick query for finding your data distributions and recommendations on fixing indexes if you have skewed data.
Greg continues with Advent of Code series, this one is puzzle 17. This one works with falling rocks. Using sequences, arrays, and aggregates he makes a stackable objects with nothing but SQL!
Greg continues with more puzzles and solutions for the Advent of Code series, today covering day 18's puzzle. Greg has some amazing functions for surface area, heat maps, and 3d visualizations.
Karen Jex talked about how PostgreSQL "just works" as a database for your Django applications, but with knowledge of a handful of configuration parameters, you can make it work even better, at DjangoCon Europe.