Articles by Tag #indexes

Browse our collection of articles on various topics related to IT technologies. Dive in and explore something new!

pg-index-health – a static analysis tool for you PostgreSQL database

Hello there! Since 2019, I have been developing an open-source tool called pg-index-health, which...

Learn More 4 0Jan 6

How to Postgres indexes review

Hey, in addition to Part 2, I recently started to review indexes in one of my prod databases. I would...

Learn More 1 0Feb 25

IndexIVFFlat y IndexIVFPQ

Here's a comparison between the IndexIVFFlat and IndexIVFPQ indices, along with some alternatives for...

Learn More 0 0Oct 9 '24

Unleashing MongoDB: Why Cursor-Based Pagination Outperforms Offset-Based Pagination Every Time!

Pagination is a critical part of any database operation when dealing with large datasets. It allows...

Learn More 0 0Sep 4 '24

How Database Indexes Improve SQL Query Performance

SQL query performance can suffer as datasets grow. The solution? Database indexes. By organizing data...

Learn More 0 0Feb 6