21 minutes
Introduction to PostgreSQL Indexes
Who’s this for
This text is for developers that have an intuitive knowledge of what database indexes are, but don’t necessarily know how they work interna...
Similar Articles (10 found)
🔍 70.7% similar
What Does It Mean for a Column to Be Indexed
When optimizing queries on a database table, most developers tend to just create an index on the field to...
🔍 65.8% similar
9 min read
Feb 02, 2026
Table of contents
01 The “Use the Right Tool” Trap02 Why This Matters Now: The AI Era03 “But Specialized Databases Are Better!...
🔍 64.3% similar
What is a good algorithm-to-purpose map for ML beginners? Looking for something like "Algo X is good for making predictions when your data looks like ...
🔍 62.0% similar
There are books & many articles online, like this one arguing for using Postgres for everything. I thought I’d take a look at one use case - using Pos...
🔍 61.2% similar
There’s a tried-and-true architecture that I’ve seen many times for supporting your web services and applications:
- PostgreSQL for data storage
- Red...
🔍 59.8% similar
Products & Services
Support Services
Support options for your use case, infrastructure, and budget
Workloads
Open-Source Extensions and Tools
Time Ser...
🔍 59.0% similar
Python is, in a lot of ways, a very rich language. After years of using it, I still regularly discover new parts of the ecosystem, even in the standar...
🔍 58.9% similar
Build Your Own Database
A step-by-step guide to building a key-value database from scratch.
If you were to build your own database today, not knowing ...
🔍 58.1% similar
I wish there was some sort of an Access-like form/app builder tool for quickly building GUIs around SQLite databases. That's the one thing I miss. I'd...
🔍 58.0% similar
Relational Databases Explained
How Relational Databases Work. This post talks about how indexes and transactions work on the inside of relational data...