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 l\u00ebshim, u fokusuam n\u00eb rritjen e performanc\u00ebs, p\u00ebrshpejtimin e sh\u00ebrbimeve t\u00eb brendshme t\u00eb mb\u00ebshtetjes dhe thjeshtimin e monitorimit t\u00eb baz\u00ebs s\u00eb t\u00eb dh\u00ebnave, si dhe n\u00eb nj\u00eb kontroll m\u00eb t\u00eb besuesh\u00ebm t\u00eb qasjes n\u00eb sistem.<\/p>\n
Vazhdoi puna mbi optimizimin e indeksimit t\u00eb tabelave n\u00eb lidhje me p\u00ebrpunimin e kopjeve t\u00eb dh\u00ebnash mes t\u00eb dh\u00ebnave t\u00eb indeksuara n\u00eb pem\u00ebt binare t\u00eb indekseve, e cila jo vet\u00ebm q\u00eb p\u00ebrshpejton ekzekutimin e pyetjeve, por gjithashtu zvog\u00eblon hap\u00ebsir\u00ebn diskore t\u00eb z\u00ebn\u00eb nga indeksi.
\nP\u00ebrve\u00e7 k\u00ebsaj, \u00ebsht\u00eb shtuar nj\u00eb algoritem i renditjes incrementale, i cili b\u00ebn q\u00eb renditja e t\u00eb dh\u00ebnave t\u00eb renditura n\u00eb hapet e m\u00ebparshme t\u00eb funksionoj\u00eb m\u00eb shpejt, dhe disa pyetjeve mund t'u arrijm\u00eb p\u00ebrshpejtim duke p\u00ebrdorur statistika t\u00eb reja t\u00eb zgjeruara (p\u00ebrmes komand\u00ebs CREATE STATISTICS) gjat\u00eb p\u00ebrllogaritjes s\u00eb nj\u00eb plani m\u00eb efektiv hap pas hapi.
\nGjithashtu, \u00ebsht\u00eb optimizuar ekzekutimi i k\u00ebrkesave me agregimin e dh\u00ebnash t\u00eb shpenzuesh\u00ebm p\u00ebrmes p\u00ebrdorimit m\u00eb t\u00eb gjer\u00eb t\u00eb agregimit t\u00eb hash-it dhe shkarkimit t\u00eb nj\u00eb pjese t\u00eb dh\u00ebnave t\u00eb agreguara n\u00eb disk, n\u00ebse ato nuk i p\u00ebrshtaten memorjes operative. V\u00ebrehet nj\u00eb rritje e konsiderueshme e shpejt\u00ebsis\u00eb n\u00eb lidhjen e tabelave t\u00eb vendosura n\u00eb seksione t\u00eb ndryshme.<\/p>\n
\u00cbsht\u00eb b\u00ebr\u00eb nj\u00eb pun\u00eb e madhe edhe n\u00eb fush\u00ebn e thjeshtimit t\u00eb sh\u00ebrbimit dhe administrat\u00ebs s\u00eb bazave t\u00eb t\u00eb dh\u00ebnave Postgresql. Detyra e integruar \"vakumimit\", q\u00eb do t\u00eb thot\u00eb p\u00ebrdorimi i hap\u00ebsir\u00ebs s\u00eb lir\u00eb n\u00eb disk pas fshirjes ose rishkruese s\u00eb rreshtave, tani mund t\u00eb kryhet n\u00eb m\u00ebnyr\u00eb paralel, duke i dh\u00ebn\u00eb administratorit mund\u00ebsin\u00eb t\u00eb specifikoj\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 log\u00ebve t\u00eb regjistrimit midis masterit dhe kopjeve, q\u00eb mund t\u00eb shkaktonte konflikte kur \u00e7aktivizoheshin kopjet apo t\u00eb d\u00ebmtonte integritetin e baz\u00ebs t\u00eb shp\u00ebrndar\u00eb pas rikuperimit t\u00eb saj mbi t\u00eb dh\u00ebnat e regjistrit.<\/p>\n
Nd\u00ebr risit\u00eb p\u00ebr zhvilluesit meritojn\u00eb t\u00eb ve\u00e7ohet funksioni datetime(), q\u00eb konverton formate t\u00eb ndryshme standarde t\u00eb sh\u00ebnimit t\u00eb koh\u00ebs n\u00eb tipin e integruar Postgresql; funksioni i gjenerimit UUID v4 gen_random_uuid() i disponuesh\u00ebm nga kutia; normalizimi n\u00eb pun\u00ebn me unicode; nj\u00eb sistem m\u00eb fleksib\u00ebl p\u00ebr shp\u00ebrndarjen e t\u00eb dh\u00ebnave t\u00eb tabel\u00ebs n\u00eb nyjet e lidhura t\u00eb rrjetit t\u00eb baz\u00ebs me replikim t\u00eb plot\u00eb n\u00eb nivelin logjik, si dhe ndryshime t\u00eb tjera n\u00eb pyetje dhe n\u00eb trigera t\u00eb rinj t\u00eb disponuesh\u00ebm p\u00ebr replikat.<\/p>\n
Kontrolli i aksesit n\u00eb baz\u00ebn e t\u00eb dh\u00ebnave 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 instalimi i zgjerimeve n\u00eb baz\u00eb mund t\u00eb b\u00ebhet vet\u00ebm nga nj\u00eb p\u00ebrdorues me privilegje (superuser). Nd\u00ebrkoh\u00eb, p\u00ebrdoruesit e zakonsh\u00ebm do t\u00eb mund t\u00eb instalojn\u00eb vet\u00ebm ato zgjerime q\u00eb ata i kan\u00eb etiketuar si t\u00eb besueshme, ose nj\u00eb num\u00ebr t\u00eb vog\u00ebl zgjerimesh q\u00eb konsiderohen t\u00eb besueshme nga parazgjedhja (p.sh., pgcrypto, tablefunc ose hstore). Gjat\u00eb autentikimit t\u00eb p\u00ebrdoruesve me mekanizmin SCRAM (kur punoni me driverin libpq) tani k\u00ebrkohet nj\u00eb \"kanal i lidhur\", dhe funksioni i mbushjes p\u00ebr t\u00eb dh\u00ebna t\u00eb huaja postgres_fdw nga versioni 13 mb\u00ebshtet autorizimin p\u00ebrmes certifikatave.<\/p>\n