# Anyone know of an in-depth guide for database indexing?

**URL:** <https://metaruby.com/t/anyone-know-of-an-in-depth-guide-for-database-indexing/1093>\
**Category:** Rails Forum\
**Tags:** postgresql, rails\
**Created:** [June 19, 2017, 5:38pm UTC](https://metaruby.com/t/anyone-know-of-an-in-depth-guide-for-database-indexing/1093 "2017-06-19T17:38:31Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![MatiasFMolinari](https://metaruby.com/letter_avatar_proxy/v4/letter/m/f04885/32.png) [@MatiasFMolinari](https://metaruby.com/u/MatiasFMolinari)\
**Post date:** [June 19, 2017, 5:38pm UTC](https://metaruby.com/t/anyone-know-of-an-in-depth-guide-for-database-indexing/1093/1 "2017-06-19T17:38:31Z")

</div>

I’ve been looking for an in-depth guide on database indexing that includes performance benchmarks and possibly anti-patterns.

Most guides stop short on comparing indexed vs non-indexes performance, but I’m looking for something more.

For example, I want to know the performance impact of multi-indexed columns vs single indexed. Or the performance impact of having 4 multi-indexed columns. Or the performance impact on writes from having too many indexes. Etc.

So far, I’ve been making the measurements myself, but I’d love to see if there’s something out there I can compare my results to.