An unexpected find that freed 20GB of unused index space (2021) (hakibenita.com)

Screenshot of hakibenita.com: An unexpected find that freed 20GB of unused index space (2021)

First screen, captured 3 years ago.

Looks similar

Screenshot of avi.im: Fun facts about SQLite

Fun facts about SQLite (avi.im)

310 points by avinassh 1 year ago | 127 comments

Screenshot of avi.im: Replacing a cache service with a database

Replacing a cache service with a database (avi.im)

55 points by avinassh 1 year ago | 55 comments

Screenshot of andersmurphy.com: The perils of UUID primary keys in SQLite

The perils of UUID primary keys in SQLite (andersmurphy.com)

142 points by emschwartz 4 months ago | 87 comments

Screenshot of hakibenita.com: Unconventional PostgreSQL Optimizations

Unconventional PostgreSQL Optimizations (hakibenita.com)

398 points by haki 9 months ago | 63 comments

Blog post by Haki Benita presenting unconventional, creative techniques for speeding up queries in PostgreSQL beyond standard indexing and query rewrites.

postgresql query-optimization database-performance sql

Screenshot of datafusion.apache.org: Embedding user-defined indexes in Apache Parquet

Embedding user-defined indexes in Apache Parquet (datafusion.apache.org)

131 points by jasim 1 year ago | 20 comments

Screenshot of pganalyze.com: An automatic indexing system for Postgres

An automatic indexing system for Postgres (pganalyze.com)

223 points by ako 2 years ago | 40 comments

Looks similar

Fun facts about SQLite(avi.im)

Replacing a cache service with a database(avi.im)

The perils of UUID primary keys in SQLite(andersmurphy.com)

Unconventional PostgreSQL Optimizations(hakibenita.com)

Embedding user-defined indexes in Apache Parquet(datafusion.apache.org)

An automatic indexing system for Postgres(pganalyze.com)