/explore

Click through on any links that interest you or select the planets on the right to continue exploring the Outer Web.
You are here

 jazco.dev
Speeding up Postgres Queries by 200x with Analyze ยท Jaz's Blog
| | ottertune.com
Run ANALYZE. Run ANALYZE. Run ANALYZE. | OtterTune
4.5 parsecs away

Travel
| | We've said it before, we'll say it again: one of the first things you should do, if not the first, when trying to solve a slow-running PostgreSQL query problem is run ANALYZE
| | www.crunchydata.com
Hacking the Postgres Statistics Tables for... | Crunchy Data Blog
6.0 parsecs away

Travel
| | 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 query performance.
| | boringsql.com
Production query plans without production data | boringSQL
6.8 parsecs away

Travel
| | PostgreSQL 18 makes optimizer statistics portable. Export them from production and inject them into test databases to get realistic query plans without the data.
| | hop.ie
Lazy loading images in Svelte - hop.ie
33.8 parsecs away

Travel
| Speed up your website render time by only loading the images you want to show