Reindex database

bash

reindexdb -h localhost -U postgres -d appdb --concurrently

Explanation

See summary for usage details.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Same sheet · prioritizing Database Administration Utilities

Rewrite a table using an index order.

Open In sheetsqlsame section

Create a database using the `createdb` utility.

Open In sheetbashsame section

Drop a database using the `dropdb` utility.

Open In sheetbashsame section

Interactively create a new role.

Open In sheetbashsame section

Remove a role using the command-line utility.

Open In sheetbashsame section

Run vacuum/analyze from the shell.

Open In sheetbashsame section