2 ms·
See "Cluster ON" in PostgreSQL. Note that with this, you don't have to use unique indexes to indicate on-disk layout. Of course cluster needs to be run occasi
by einhverfr 15y ago
See "Cluster ON" in PostgreSQL.
Note that with this, you don't have to use unique indexes to indicate on-disk layout. Of course cluster needs to be run occasionally but it is far more capable.
- ryandvm 15y agoWhile CLUSTER is great for optimizing a given index, as of 9.1, it still requires an exclusive lock (no reads or writes). http://www.postgresql.org/docs/9.1/static/sql-cluster.html http://www.postgresql.org/docs/9.1/static/sql-cluster.html
- deleted 15y ago[deleted]