Commands.app

reindexdb

Maintenance

Rebuild PostgreSQL database indexes

Options & Flags
Available options for this command
-a

Reindex all databases

-t

Reindex specific table

-i

Reindex specific index

Examples
Common usage examples

Reindex all indexes in database

reindexdb mydb

Reindex only users table

reindexdb -t users mydb
Notes
  • Useful after bulk operations
  • Can improve query performance
Related Commands
You might also find these useful