Posts tagged "statistics"

100daysofcode 100daysofdevops 100pay 10mistakes 10yearworkanniversary 11 11labs 11tly 11ty 127001

Statistics for Strava, a self-hosted service for better stats

Hi, The last months I've been working really hard (after hours) developing "Statistics for Strava". It's a self-hosted web app designed to provide you with better stats.The app includes, but is not li...

25.03.2025 0 Read More

Estimating Compressed File Size

Estimating compressed sizes of large directories is crucial for storage planning and workflow optimization, but doing it efficiently requires balancing accuracy and computational cost. Let’s explore...

03.04.2025 0 Read More

The effect of frequent values on histogram_bounds in PostgreSQL

In a recent blog post, I explored statistics in PostgreSQL, with a focus on how the database engine builds histogram bounds during the ANALYZE process. These histograms are critical for query planning...

06.04.2025 0 Read More

Investigating PostgreSQL's `ANALYZE` Runtime Behavior: Sampling, Table Size, and Cache Effects

PostgreSQL's ANALYZE command is designed to collect statistics for the query planner by sampling a fixed number of pages from a table. As per the documentation, when default_statistics_target is 100, ...

06.04.2025 0 Read More

Statistics for Strava, a self-hosted service for better stats

Estimating Compressed File Size

The effect of frequent values on histogram_bounds in PostgreSQL

Investigating PostgreSQL's `ANALYZE` Runtime Behavior: Sampling, Table Size, and Cache Effects

#reading

#popular