Browse categories
Random entry
Blog
PostgreSQL releases
- PostgreSQL 16 (dev)
- PostgreSQL 15 (latest)
- PostgreSQL 14
- PostgreSQL 13
- PostgreSQL 12
- PostgreSQL 11
- PostgreSQL 10 (EOL)

Version charts

SQL commands
System catalog tables
System catalog views
System statistics views
File system functions

Contrib modules
Object Identifier Types
Progress reporting views
Storage parameters (relopts)
Predefined roles

Useful overviews

xlog renaming in Pg 10
Online tools for PostgreSQL
Abbreviations and acronyms

Useful links

PostgreSQL documentation
PostgreSQL feature matrix
PostgreSQL versioning policy
PostgreSQL latest versions

@postgrespedia

Contents

Change history
References
Categories
See also

CLUSTER

An SQLcommand for clustering a table according to an index

CLUSTER is a utility command for clustering a table according to an index.

CLUSTER has always been present in PostgreSQL.

Change history

PostgreSQL 15
- CLUSTER can now be executed on partitioned tables (commit cfdd03f4)
PostgreSQL 8.4
- option VERBOSE added (commit a3785555)
PostgreSQL 7.4
- parameter-less invocation to cluster all previously clustered tables (commit 8bc717cb)
- tables which were previously clustered can now be clustered with "CLUSTER TABLE table_name" (commit 8bc717cb)

References

PostgreSQL documentation: CLUSTER

Categories

See also