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