Скачать или смотреть Tutorial 34-What Is a REINDEX in PostgreSQL? | PostgreSQL REINDEX

In this session, we are going to discuss PostgreSQL ReIndex

What is a REINDEX in postgresql?

It rebuilds the index using the data stored in the index table. replacing the old copy of the index.

As a simple definition Rebuild-index would defragment the index and therefore also reduce its size.


When to use REINDEX in postgresql?

The index has become corrupted, and no longer contains valid data. It provides a recovery method.

The index contains a lot of mostly empty index pages that are not being reclaimed. Postgresql REINDEX provides a way to reduce the space consumption of the index by writing a new the version of the index without the dead pages.


To Join our Telegram Channel:


https://t.me/DBHunters

#PostgresqlREINDEX #REINDEX #INDEX