---
title: "#b-tree-indexing articles | Hashnode"
description: "Explore 2 articles tagged #b-tree-indexing on Hashnode. Tutorials, guides, and how-tos from the community."
url: "https://hashnode.com/tag/b-tree-indexing"
---

Tag

# #b-tree-indexing

2 posts · 0 followers

[John M Harper](https://hashnode.com/@j79h110) · [May 7, 2025](https://hashnode.com/posts/brin-vs-b-tree-indexes-in-postgresql-a-definitive-guide/681af7bba56c5ee9faa10917)

### [BRIN vs B-tree Indexes in PostgreSQL: A Definitive Guide](https://sqljournal.hashnode.dev/brin-vs-b-tree-indexes-in-postgresql-a-definitive-guide?utm_source=hashnode&utm_medium=feed)

In PostgreSQL indexing, B-tree indexes have long been the default choice for most use cases. However, BRIN indexes are often considered a more space-efficient alternative when dealing with multi-billion-row tables. But do they live up to the hype? Th...

7 min read · [sqljournal.hashnode.dev](https://sqljournal.hashnode.dev/brin-vs-b-tree-indexes-in-postgresql-a-definitive-guide?utm_source=hashnode&utm_medium=feed)

[Sergey Shishkin](https://hashnode.com/@Serj-Aleks) · [May 7, 2025](https://hashnode.com/posts/index-index/681b08877cc5f6572036bdb8)

### [index ... +index](https://serj-aleks.hashnode.dev/index-index?utm_source=hashnode&utm_medium=feed)

+index - абстрактный базовый класс всех индексных отношений B-Tree базы данных (префиксный класс для +relation). Иерархия классов включает +Key, +Ref, +Idx и +IdxFold. (isa '+index Rel) # Check for an index relation index - возвращает позицию cnt a...

1 min read · [serj-aleks.hashnode.dev](https://serj-aleks.hashnode.dev/index-index?utm_source=hashnode&utm_medium=feed)
