louisemeta.bsky.social
@louisemeta.bsky.social
Reposted
@crunchydata.com will be present at PG Day France (pgday.fr) at Mons, Belgium ;-)

@karenhjex.bsky.social will present "Postgres sur Kubernetes pour le DBA réticent"

@louisemeta.bsky.social will present "Voyage au centre des statistiques dans Postgres"

Come and share #PostgreSQL love with us!
PG Day France
Conférence de la communauté PostgreSQL les 3-4 juin à Mons (Belgique)
pgday.fr
May 13, 2025 at 8:16 AM
Reposted
I've learned over the years when @louisemeta.bsky.social tells me she has an idea for a blog post I don't hesitate, just simply ask when can I see it because I know it's going to be awesome. This is no exception
Postgres does a good job of keeping internal statistics of your which are used to plan how queries are executed. But Postgres doesn't always know how columns are related. In this deep dive we look at hacking the statistics for improved performance
Hacking the Postgres Statistics Tables for Faster Queries | Crunchy Data Blog
Adding extended statistics can add information about how columns are related. Louise has some real life example queries and tips for working with extended table stats that can dramatically improve…
www.crunchydata.com
April 16, 2025 at 2:01 PM