Monday, September 14, 2015
A little reminder of why #statistics matter, and how to #tune your #PostgreSQL instance.
Thomas Vondra writes a good recap of why statistics matter in tuning a PostgreSQL instance: "That however does not mean there are no issues with data distribution (planner) statistics, and as that's one of my areas of interest, in this post I'll discuss the usual issues with data distribution statistics, usually observed by the user as slow (or even failing) queries. And I'll also mention what are the possible remedies available (if any)." Common issues with planner statistics