Musi waSeptember 24, boka rekuvandudza rakazivisa kusunungurwa kweiyo inotevera Postgresql kusunungurwa nhamba 13. Kusunungurwa kutsva kwakatarisa, pakati pezvimwe zvinhu, pakuvandudza kushanda, kukurumidza kufambisa mabasa ekuchengetedza mukati uye kurerutsa kutarisa kwedatabase, pamwe chete nekutendeseka kwekutonga kwekuwana nzira.
Basa rakaenderera mberi pakugadzirisa tafura indexing maererano nekugadzirisa zvinyorwa pakati pe data indexed mubhinari index miti, izvo zvakaita kuti zvikwanisike kwete kungokurumidzira kubvunzurudzwa kwemibvunzo, asiwo kuderedza dhisiki nzvimbo inobatwa nendekisi.
Pamusoro pezvo, imwe yekuwedzera yekuronga algorithm yakawedzerwa, umo kudzokororwa kurongeka kwedata rakatorongwa mumatanho apfuura kunoshanda nekukurumidza, uye mimwe mibvunzo inogona kukwidziridzwa nekushandisa hutsva hwakawedzerwa nhamba (kuburikidza neCREATE STATISTICS command) paunenge uchiverenga nhanho inoshanda- ne-danho chirongwa.
Kuitwa kwemibvunzo ine inodhura data aggregation yakagadziridzwa zvakare nekushandisa zvakanyanya kukurumidza kuunganidza uye kurasira chikamu che data rakaunganidzwa kudhisiki kana isingakwane mu RAM. Pane kuwedzera kukuru kwekukurumidza kwekubatanidza matafura ari pazvikamu zvakasiyana.
Basa rakakura rakaitwa kurerutsa kuchengetedza uye kutonga kwePostgresql dhatabhesi. Basa rakavakirwa-mukati re "vacuuming", ndiko kuti, kushandisa yemahara dhisiki nzvimbo mushure mekudzima kana kunyorazve mitsara, ikozvino inogona kuurayiwa mumitsetse yakafanana, uye mutungamiriri iye zvino ane mukana wekutsanangura nhamba yavo. Pamusoro peizvi, maturusi matsva akawedzerwa ekutarisa chiitiko chazvino chedhatabhesi uye zvikanganiso zvakadzivirirwa pakuwiriranisa pre-record matanda pakati pe master uye replicas, izvo zvinogona kukonzera kukakavara pakubvisa replicas kana kukanganisa kuvimbika kweakagoverwa. dhatabhesi mushure mekunge vadzoreredzwa zvichibva pane data regi.
Pakati pezvitsva zvevagadziri, zvakakodzera kuratidza iyo datetime() basa, iro rinoshandura akasiyana akajairwa nguva yekurekodha mafomati kuita yakavakirwa-mukati Postgresql mhando; UUID chizvarwa basa v4 inowanikwa kunze kwebhokisi gen_random_uuid(); normalization yebasa ne Unicode; imwe inoshanduka-shanduka sisitimu yekugovera tafura data pane yakabatana network node yedhatabhesi ine yakazara kudzokorora pamwero unonzwisisika, pamwe nekumwe shanduko mumibvunzo uye zvitsva zvinokonzeresa zviripo kune replicas.
Database yekuwana control inotaurwa seimwe yeakakosha zvikamu zvehurongwa, uye iyo nyowani vhezheni inoita nhanho huru kumberi mune izvi. Iye zvino mushandisi ane rombo chete (superuser) anogona kuisa mawedzero kudhatabhesi. Panguva imwecheteyo, vashandisi vakajairwa vanozokwanisa kuisa chete iwo ekuwedzera avakamaka seakavimbika, kana seti diki yekuwedzera iyo inoonekwa seyakavimbika nekusarudzika (semuenzaniso, pgcrypto, tablefunc kana hstore). Paunenge uchisimbisa vashandisi vachishandisa iyo SCRAM michina (kana uchishanda kuburikidza ne libpq mutyairi), "chiteshi chinosunga" chave kudiwa, uye basa rekuputira rechitatu-bato data postgres_fdw kubva muvhezheni 13 inotsigira mvumo yechitupa.
Source: linux.org.ru