Siideynta saxda ah ee PostgreSQL DBMS 14.4 ayaa la abuuray, taas oo meesha ka saaraysa dhibaato halis ah, xaaladaha qaarkood, waxay keenaysaa musuqmaasuqa xogta aan muuqan ee tusmooyinka marka la fulinayo amarrada "CREATE INDEX ISKU SOCDA" iyo "REINDEX ISKU ARKAY". Tusmooyinka la sameeyay iyadoo la adeegsanayo amarada la cayimay, diiwaanada qaar ayaa laga yaabaa inaan xisaabta lagu darin, taasoo horseedi doonta in safaf la waayo marka la fulinayo weydiimaha SELECT ee ku lug leh tusmooyinka dhibaatada leh.
Si loo go'aamiyo in tusmooyinka B-geed ay dhaawacmeen, waxaad isticmaali kartaa amarka "pg_amcheck -heapallindexed db_name". Haddii khaladaadka la aqoonsado ama amarrada "SAMEE INDEX ISKU SOCDA" iyo "REINDEX ISKU SOCOTA" ayaa loo adeegsaday siidooyinkii hore ee noocyada kale ee tusmooyinka (GiST, GIN, iwm.), ka dib markii la cusbooneysiiyay nooca 14.4, waxaa lagu talinayaa in la sameeyo dib u habeyn iyadoo la adeegsanayo "reindexdb -all" utility ama amarka "REINDEX SI CONCURRENTLY index_name."
Dhibaatadu waxay saamaysaa oo kaliya laanta 14.x, oo ay ku jiraan hagaajinta ka saaraysa qaar ka mid ah macaamilada la xidhiidha fulinta "CREATE INDEX ISKU SOCDA" iyo "REINDEX ISKU SOCDA" marka la fulinayo hawlgalka VACUUM. Natiijadii ka soo baxday wanaajintan, tusmooyinka loo sameeyay qaabka ISKU-KU-XIQDA kuma jiraan qaar ka mid ah tuples xusuusta tuulan oo la cusboonaysiiyay ama la gooyay intii lagu jiray abuurista index.
Source: opennet.ru