M\u00eb 24 Shtator, ekipi i zhvilluesve njoftoi l\u00ebshimin e versionit t\u00eb ri t\u00eb Postgresql me num\u00ebr 13. N\u00eb k\u00ebt\u00eb version, u p\u00ebrqendrua kryesisht n\u00eb p\u00ebrmir\u00ebsimin e performanc\u00ebs, p\u00ebrshpejtimin e sh\u00ebrbimeve t\u00eb brendshme t\u00eb mir\u00ebmbajtjes dhe leht\u00ebsimin e monitorimit t\u00eb baz\u00ebs s\u00eb t\u00eb dh\u00ebnave, si dhe kontrollin m\u00eb t\u00eb besuesh\u00ebm t\u00eb aksesit n\u00eb sistem.<\/p>\n
Puna vazhdoi mbi optimizimin e indekseve t\u00eb tabelave n\u00eb lidhje me trajtimin e kopjeve t\u00eb dh\u00ebnash midis t\u00eb dh\u00ebnave t\u00eb indekseve n\u00eb pem\u00ebt binare, duke lejuar k\u00ebshtu jo vet\u00ebm p\u00ebrshpejtimin e ekzekutimit t\u00eb k\u00ebrkesave, por gjithashtu zvog\u00eblimin e hap\u00ebsir\u00ebs s\u00eb diskut q\u00eb z\u00eb indeksi.
\nP\u00ebrve\u00e7 k\u00ebsaj, u shtua nj\u00eb algorit\u00ebm i renditjes incrementale, q\u00eb b\u00ebn q\u00eb rin\u00ebnd\u00ebrtimi i t\u00eb dh\u00ebnave t\u00eb renditura n\u00eb hapat e m\u00ebparsh\u00ebm t\u00eb pun\u00ebs t\u00eb funksionoj\u00eb m\u00eb shpejt, dhe p\u00ebr nj\u00eb pjes\u00eb t\u00eb k\u00ebrkesave, p\u00ebrshpejtimi mund t\u00eb arrihet p\u00ebrmes p\u00ebrdorimit t\u00eb statistikave t\u00eb reja t\u00eb avancuara (n\u00ebp\u00ebrmjet komand\u00ebs CREATE STATISTICS) gjat\u00eb p\u00ebrllogaritjes s\u00eb nj\u00eb plani m\u00eb efektiv hapi pas hapi.
\ngjithashtu \u00ebsht\u00eb optimizuar ekzekutimi i k\u00ebrkesave me agregimin e kushtuesh\u00ebm t\u00eb t\u00eb dh\u00ebnave p\u00ebrmes p\u00ebrdorimit m\u00eb t\u00eb gjer\u00eb t\u00eb agregimit t\u00eb hashe dhe heqjes s\u00eb nj\u00eb pjese t\u00eb t\u00eb dh\u00ebnave t\u00eb agreguara n\u00eb disk, n\u00ebse ato nuk p\u00ebrshtaten n\u00eb memorien operative. U v\u00ebrejt nj\u00eb rritje t\u00eb konsiderueshme t\u00eb shpejt\u00ebsis\u00eb s\u00eb lidhjes s\u00eb tabelave t\u00eb vendosura n\u00eb nj\u00ebsi t\u00eb ndryshme.<\/p>\n
Nj\u00eb pun\u00eb e konsiderueshme \u00ebsht\u00eb b\u00ebr\u00eb gjithashtu n\u00eb fush\u00ebn e thjeshtimit t\u00eb mir\u00ebmbajtjes dhe administrat\u00ebs s\u00eb bazave t\u00eb t\u00eb dh\u00ebnave Postgresql. Detyra e nd\u00ebrtuar 'vakumimit', dometh\u00ebn\u00eb p\u00ebrdorimi i hap\u00ebsir\u00ebs s\u00eb lir\u00eb t\u00eb diskut pas fshirjes ose riprogramimit t\u00eb rreshtave, tani mund t\u00eb kryhet n\u00eb rrjedha paralelisht, duke i dh\u00ebn\u00eb administratorit mund\u00ebsin\u00eb t\u00eb p\u00ebrcaktoj\u00eb numrin e tyre. P\u00ebrve\u00e7 k\u00ebsaj, jan\u00eb shtuar mjete t\u00eb reja p\u00ebr monitorimin e aktivitetit aktual t\u00eb baz\u00ebs dhe jan\u00eb parandaluar gabimet gjat\u00eb sinkronizimit t\u00eb regjistrave t\u00eb parakohshme midis masterit dhe kopjeve, q\u00eb mund t\u00eb \u00e7onin n\u00eb konflikte gjat\u00eb \u00e7aktivizimit t\u00eb kopjeve ose t\u00eb d\u00ebmtonin integritetin e baz\u00ebs s\u00eb shp\u00ebrndar\u00eb pas rikuperimit t\u00eb saj bazuar n\u00eb t\u00eb dh\u00ebnat e regjistrit.<\/p>\n
Nd\u00ebr inovacionet p\u00ebr zhvilluesit, merret parasysh funksioni datetime(), i cili shnd\u00ebrron formate t\u00eb ndryshme standarde t\u00eb regjistrimit t\u00eb koh\u00ebs n\u00eb tipin e integruar t\u00eb Postgresql; funksioni i disponuesh\u00ebm p\u00ebr gjenerimin e UUID v4 gen_random_uuid(); normalizimi i pun\u00ebs me Unicode; nj\u00eb sistem m\u00eb fleksib\u00ebl t\u00eb shp\u00ebrndarjes s\u00eb t\u00eb dh\u00ebnave t\u00eb tabelave n\u00eb nyje t\u00eb lidhura t\u00eb rrjetit t\u00eb baz\u00ebs me replikim t\u00eb plot\u00eb n\u00eb nivel logjik, si dhe ndryshime t\u00eb tjera n\u00eb pyetje dhe trigger-e t\u00eb reja t\u00eb disponueshme p\u00ebr replikat.<\/p>\n
Kontrolli i aksesit n\u00eb baz\u00eb shpallet si nj\u00eb nga komponent\u00ebt ky\u00e7 t\u00eb sistemit, dhe n\u00eb versionin e ri jan\u00eb b\u00ebr\u00eb hapa t\u00eb m\u00ebdha p\u00ebrpara n\u00eb k\u00ebt\u00eb drejtim. Tani instalimin e zgjerimeve n\u00eb baz\u00eb mund ta kryej\u00eb vet\u00ebm nj\u00eb p\u00ebrdorues me privilegje (superuser). Nd\u00ebrkoh\u00eb, p\u00ebrdoruesit e zakonsh\u00ebm do t\u00eb jen\u00eb n\u00eb gjendje t\u00eb instalojn\u00eb vet\u00ebm ato zgjerime q\u00eb i kan\u00eb sh\u00ebnuar si t\u00eb besueshme, ose nj\u00eb num\u00ebr t\u00eb vog\u00ebl zgjerimesh q\u00eb konsiderohen si t\u00eb besueshme nga parimi (p.sh., pgcrypto, tablefunc ose hstore). Gjat\u00eb autentifikimit t\u00eb p\u00ebrdoruesve me mekanizmin SCRAM (kur punoni p\u00ebrmes s\u00fcrferit libpq) tani k\u00ebrkohet 'marr\u00ebveshja e kanalit', nd\u00ebrsa funksioni i mb\u00ebshtjell\u00ebs p\u00ebr t\u00eb dh\u00ebnat e pal\u00ebve t\u00eb treta postgres_fdw me versionin 13 mb\u00ebshtet autorizimin p\u00ebrmes certifikatave.<\/p>\n