Magadzirirwo ekugadzirisa akagadzirwa kune ese anotsigirwa mapazi ePostgreSQL: 14.2, 13.6, 12.10, 11.15 uye 10.20, ayo anogadzirisa 55 zvikanganiso zvakaonekwa mumwedzi mitatu yapfuura. Pakati pezvimwe zvinhu, isu takagadzirisa matambudziko ayo, mune zvisingawanzo kuitika, akatungamira kune index uwori pakuchinja HOT (murwi-chete tuple) maketani panguva yeVACUUM oparesheni kana pakuita REINDEX CONCURRENTLY mashandiro pane indexes pamatafura anoshandisa TOAST kuchengetedza michina.
Kusaputsika kwakagadziriswa paunenge uchiita ALTER STATISTICS uye paunotora data nemhando dzakasiyana siyana. Mabugs ari mu query planner akakonzeresa mhedzisiro akagadziriswa. Yakagadziriswa ndangariro inodonha kana uchigadziridza indexes uchishandisa mataurirwo uye kana uchiita REASSIGN OWNED BY oparesheni pahuwandu hwezvinhu. Kuvakwa kwehuwandu hwepamusoro hwematafura akapatsanurwa anopihwa.
Pamusoro pezvo, isu tinogona kucherechedza kuburitswa kweiyo reshape utility, iyo inokutendera iwe kuti uite zvakaomarara zvigadziriso kune data schema muPostgreSQL pasina kumisa basa, iro pasi pemamiriro akajairwa rinoda shanduko yemanyorero uye kuvharika kwenguva pfupi kwemasevhisi uchishandisa dhatabhesi. Izvo zvinoshandiswa zvinoita kuti zvikwanise kushandura kubva kune yekare data scheme kuenda kune itsva pasina kuvharika kwenguva refu uye pasina kukanganisa kutenderera kwekukumbira. Iyo yekushandisa inogadzira otomatiki maonero etafura ayo maapplication anoramba achishanda nawo panguva yekufambisa schema data, uye zvakare inogadzirisa zvinokonzeresa zvinoshandura mashandiro ekuwedzera nekudzima data pakati pechinyakare uye chitsva schemas.
Nokudaro, paunenge uchishandisa reshape panguva yekutama, schema yekare uye itsva inoramba iripo panguva imwe chete uye zvikumbiro zvinogona kuendeswa zvishoma nezvishoma kune schema itsva pasina kumira basa (muzvivako zvakakura, vabati vanogona kuchinjwa zvishoma nezvishoma kubva kune yekare kusvika kune itsva). Kana kutama kwezvikumbiro kune schema nyowani kwapera, maonero uye zvinokonzeresa zvakagadzirirwa kuchengetedza rutsigiro rwekare schema zvinobviswa. Kana matambudziko nemaapplication akaonekwa panguva yekutama, unogona kudzosera shanduko ye schema uye wodzokera kune yekare mamiriro.
Source: opennet.ru