https://www.crunchydata.com/blog/postgis-performance-improve-bounding-boxes-with-decompose-and-subdivide
PostGIS Performance: Improve Bounding Boxes... | Crunchy Data Blog
Large multi-part geometries can have massive poorly-fitting bounding boxes that cover large areas of the ocean. Paul shows you how to make bounding boxes more...
crunchy data blogpostgisboxes
https://www.crunchydata.com/blog/is-postgres-read-heavy-or-write-heavy-and-why-should-you-care
Is Postgres Read Heavy or Write Heavy? (And Why... | Crunchy Data Blog
A query to find out if Postgres is read heavy or write heavy and tips for optimizing Postgres for both read and write workloads.
postgresreadheavywritecrunchy