why use PostgreSQL clusterdb instruction I have come across recommendation for 1C:Enterprise on PostgreSQL. It says that we should periodically use clusterdb command but with no details.
PostgreSQL documentation says: &quot;clusterdb is a utility for reclustering tables in a PostgreSQL database&quot;, but what does it mean &quot;reclustering&quot;?
As I come from SQL Server world I might assume that it is the same as rebuilding clustered index, but is that true?
The advice to cluster all tables to gain performance is wrong, ignore it.
What benefits from clustering a table (that is, rewriting the table in the order of one of its indexes) are index scans on that index that select many rows. Other than that, clustering is just unnecessary pain.