{"id":104434,"date":"2022-06-17T09:37:01","date_gmt":"2022-06-17T07:37:01","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/obnovlenie-postgresql-14-4-s-ispravleniem-povrezhdeniya-indeksov"},"modified":"2022-06-17T09:37:01","modified_gmt":"2022-06-17T07:37:01","slug":"obnovlenie-postgresql-14-4-s-ispravleniem-povrezhdeniya-indeksov","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sq\/blog\/novosti-interneta\/obnovlenie-postgresql-14-4-s-ispravleniem-povrezhdeniya-indeksov","title":{"rendered":"P\u00ebrdit\u00ebsimi i PostgreSQL 14.4 me rregullimin e d\u00ebmtimeve t\u00eb indekseve","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"
\u00cbsht\u00eb formuar nj\u00eb version korrektues i sistemit t\u00eb menaxhimit t\u00eb t\u00eb dh\u00ebnave PostgreSQL 14.4, i cili ka eliminuar nj\u00eb problem serioz, i cili n\u00ebn rrethana t\u00eb caktuara mund t\u00eb \u00e7oj\u00eb n\u00eb d\u00ebmtim t\u00eb paduksh\u00ebm t\u00eb t\u00eb dh\u00ebnave n\u00eb indekset kur kryhen komandat \u00abCREATE INDEX CONCURRENTLY\u00bb dhe \u00abREINDEX CONCURRENTLY\u00bb. N\u00eb indeks\u00ebt e krijuar me ndihm\u00ebn e komandave t\u00eb p\u00ebrmendura, disa regjistra mund t\u00eb mos merren parasysh, \u00e7ka do t\u00eb \u00e7onte n\u00eb kalimin e disa rreshtave gjat\u00eb ekzekutimit t\u00eb pyetjeve SELECT duke p\u00ebrfshir\u00eb indekset problematike. <\/p>\n
P\u00ebr t\u00eb p\u00ebrcaktuar faktin e d\u00ebmtimit t\u00eb indekseve B-tree, mund t\u00eb p\u00ebrdoret komand\u00ebn \u00abpg_amcheck \u2014heapallindexed emri_BD\u00bb. N\u00eb rastin e identifikimit t\u00eb gabimeve ose n\u00ebse jan\u00eb p\u00ebrdorur n\u00eb versionet e kaluara komandat \u00abCREATE INDEX CONCURRENTLY\u00bb dhe \u00abREINDEX CONCURRENTLY\u00bb me lloje t\u00eb tjera indekse (GiST, GIN etj.) pas p\u00ebrdit\u00ebsimit n\u00eb versionin 14.4, rekomandohet t\u00eb kryhet riindeksimi me utilitarin \u00abreindexdb \u2014all\u00bb ose komand\u00ebn \u00abREINDEX CONCURRENTLY emri_indeksit\u00bb. <\/p>\n
Problemi prek vet\u00ebm deg\u00ebn 14.x, n\u00eb t\u00eb cil\u00ebn jan\u00eb p\u00ebrfshir\u00eb optimizime q\u00eb p\u00ebrjashtojn\u00eb gjat\u00eb kryerjes s\u00eb operacionit VACUUM disa transaksione q\u00eb lidhen me ekzekutimin e \u00abCREATE INDEX CONCURRENTLY\u00bb dhe \u00abREINDEX CONCURRENTLY\u00bb. Si rezultat i zbatimit t\u00eb k\u00ebtyre optimizimeve, n\u00eb indekset e krijuara n\u00eb modin \u00abCONCURRENTLY\u00bb nuk kan\u00eb shkuar disa tuple t\u00eb pranishme n\u00eb memorien heap, t\u00eb cilat ishin p\u00ebrdit\u00ebsuar ose zvog\u00ebluar gjat\u00eb krijimit t\u00eb indeksit. \n Burimi: opennet.ru<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"