Ukukhishwa okulungisayo kwe-PostgreSQL DBMS 14.4 kudaliwe, okuqeda inkinga engathi sína, ngaphansi kwezimo ezithile, eholela ekonakaleni kwedatha engabonakali ezinkombeni lapho kusetshenziswa imiyalo ethi “DALA INHLOKO NGESIXOXO” kanye nethi “REINDEX NGESINYE isikhathi”. Ezinkombeni ezidalwe kusetshenziswa imiyalo eshiwo, amanye amarekhodi angase anganakwa, okuzoholela ekulahlekeni kwemigqa lapho kwenziwa imibuzo ethi KHETHA ehilela izinkomba eziyinkinga.
Ukuze unqume ukuthi izinkomba ze-B-tree zonakalisiwe, ungasebenzisa umyalo othi “pg_amcheck -heapallindexed db_name”. Uma amaphutha ekhonjwa noma imiyalo ethi “DALA I-INDEX NGESIXENYE” kanye “REINDEX CONCURRENTLY” asetshenziswe ekukhishweni kwangaphambilini nezinye izinhlobo zezinkomba (i-GiST, i-GIN, njll.), ngemva kokubuyekeza kunguqulo 14.4, kuyanconywa ukuthi wenze inkomba kabusha usebenzisa “reindexdb —konke” insiza noma umyalo othi "REINDEX CONCURRENTLY index_name."
Inkinga ithinta kuphela igatsha le-14.x, elihlanganisa ukulungiselelwa okungabandakanyi ukuthenga okuthile okuhlotshaniswa nokusetshenziswa kokuthi “DALA INHLOKO NGESIXOXO” kanye nokuthi “REINDEX NGESIXOXO” lapho wenza umsebenzi we-VACUUM. Njengomphumela walokhu kulungiselelwa, izinkomba ezidalwe ngemodi NGESIXESHANA azizange zifake ama-tuples kumemori yenqwaba abuyekezwa noma ancishiswa phakathi nokudalwa kwenkomba.
Source: opennet.ru