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
Смотрите видео Tutorial 35-PostgreSQL Cluster command | what is a cluster command in Postgresql онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь mynotesoracledba 30 Сентябрь 2021, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 902 раз и оно понравилось 10 людям.