/explore
|
You are here 
|
databasearchitects.blogspot.com | ||
| | | | |
newvick.com
b-trees database indexes partial index function-based index multi-column index |
|
| | | | | ||
| | | | |
rcoh.me
Many software engineers use database indexes every day, but few of us really understand how they work. In this post I'll explain: How indexing works in Postgres using B-Trees What B-Trees are Why they are a good fit for this problem Indexes in Postgres Postgres actually offers 4 different kinds of indexes for different use cases. In this post I'll be focusing on the "normal" index, the kind you get by default when you run create index. |
|
| | | | | ||
| | | | |
benjamincongdon.me
B-Trees are not boring, after all |
|
| | | | | ||
| | | | |
fhur.me
[AI summary] The article reflects on the evolution of software development practices, questioning whether the traditional distancing of databases from application logic was a mistake and suggesting that databases may have been designed effectively to handle complex data needs. |
|
| | | |||
