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
On this page of the site you can watch the video online Tutorial 35-PostgreSQL Cluster command | what is a cluster command in Postgresql with a duration of hours minute second in good quality, which was uploaded by the user mynoteoracledba 30 September 2021, share the link with friends and acquaintances, this video has already been watched 1,054 times on youtube and it was liked by 11 viewers. Enjoy your viewing!
