Tutorial 35-PostgreSQL Cluster command | what is a cluster command in Postgresql

in this session, we are going to discuss the postgresql cluster command or what is a cluster command in PostgreSQL what is a cluster command? A cluster command can be used to organize the data physically according to the particular index This is an SQL command that can be run on the server i.e it will tell him this is data, this is an index please organize the data accordingly to the index, this will physically sort the data and that's why an access exclusive lock is acquired. we can't run this cluster command on the prod server when it is used because it requires the access exclusive lock on the table and this entire table is shuffle because it is sorted according to the index and is sorted physically. #postgresql #cluster #clustercommand #maintenanceactivities