Cheat Sheet logoCheat Sheet Today
PostgreSQL Administration Cheat Sheet/Physically reorder table

Rewrite a table using an index order.

Back to sheetBrowse commands
Sign in to save
Section: Database Administration Utilities

Physically reorder table

sql
sql
CLUSTER orders USING idx_orders_created_at;
Explanation

Can improve locality for certain access patterns.

View in sheet →

Learn the surrounding workflow

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

Compare commandsView fixes

Related commands

Same sheet · prioritizing Database Administration Utilities
Reindex database
Rebuild indexes in a database.
OpenIn sheetbashsame section
Create database from shell
Create a database using the `createdb` utility.
OpenIn sheetbashsame section
Drop database from shell
Drop a database using the `dropdb` utility.
OpenIn sheetbashsame section
Create role from shell
Interactively create a new role.
OpenIn sheetbashsame section
Drop role from shell
Remove a role using the command-line utility.
OpenIn sheetbashsame section
Vacuum and analyze
Run vacuum/analyze from the shell.
OpenIn sheetbashsame section