I-Postgres Professional isimemezele ukutholakala kwe-DBMS Pro Enterprise 15.1.1 yokuphathelene, ngokususelwa kusisekelo sekhodi ye-PostgreSQL 15 futhi okuhlanganisa izici ezintsha ezidluliselwa ukuze zihlanganiswe emagatsheni alandelayo e-PostgreSQL, kanye nenani lezengezo ezithile zokusebenzisa okuphezulu. amasistimu wokulayisha. I-DBMS isekela ukuphindaphindwa kwe-multimaster, ukuminyanisa idatha yeleveli yebhulokhi, ikhophi yasenqolobaneni ekhuphukayo, i-pooler yokuxhumana eyakhelwe ngaphakathi, ukwahlukanisa kwetafula okuthuthukisiwe, ukusesha okugcwele okuthuthukisiwe, ukuhlanganisa imibuzo okuzenzakalelayo kanye nokuhlela.
Okuqanjiwe okuyinhloko:
- Ukusekelwa kwamaphakheji (Amaphakheji, amasethi emisebenzi nezinqubo) ngesitayela se-Oracle ukwenza lula ukufuduka kwekhodi ye-PL/SQL lapho usuka e-Oracle uya e-Postgres. Ngokombono wezobuchwepheshe, ukwesekwa kwephakeji kuyisandiso se-syntax yolimi lwe-PL/pgSQL (nezengezo ezincane ku-DBMS kernel), ngenxa yokuthi i-analogue esebenzayo yamaphakheji we-Oracle isetshenziswa futhi kwethulwa inombolo yemiyalelo eyengeziwe. ukusebenza nabo.
- Ukudlulisa amapharamitha e-positional kusikripthi ku-psql, okukuvumela ukuthi udale imibhalo yegobolondo eguquguqukayo futhi esebenza emhlabeni wonke yokusebenza nge-DBMS. Ngaphezu kwezinzuzo ezisobala lapho uklama imibhalo emisha, lokhu kuzokwenza kube lula ukuzivumelanisa nezikripthi ze-SQL lapho ufuduka usuka ku-Oracle DBMS, lapho ukusebenza okunjalo kujwayelekile kumsebenzisi.
- Isandiso se-pgpro_anonymizer sokufihla (i-obfuscation) yedatha, esikuvumela ukuthi uqinisekise ukuphepha kokugcinwa kwedatha kumasistimu ezinga lebhizinisi, futhi udale amakhophi angaziwa esizindalwazi ukuze asetshenziswe ezindaweni zokuhlola nezokuthuthukisa.
- Ngokusekelwe ku-pg_probackup, insiza entsha yokusekelayo yezindawo zezinkampani, pg_probackup Enterprise, yakhiwe, esebenzisa: uhlelo oluncane lwe-I/O olukhulisa ukusebenza; ukusekelwa kwephrothokholi ye-S3 yokugcina idatha ezinhlelweni zamafu; ukuhambisana kwe-CFS (ukucindezelwa kwedatha) nohlelo lokudala izipele ezikhuphukayo; ukusekelwa kwazo zonke izindlela zokulondoloza (i-DELTA, PAGE ne-PTRACK); ukwesekwa kwe-LZ4 kanye ne-ZSTD compression algorithms.
- Izici zokucubungula ze-JSON ezintsha kusukela ku-SQL:2016 okujwayelekile ngaphezu kolimi olusetshenziswe ngaphambilini lwe-JSONPATH.
- Ilungele ukusebenza nesandiso se-TimescaleDB (ngemuva kokuthi umthuthukisi wayo ememezele ngokusemthethweni ukwesekwa kwe-PostgreSQL 15).
- Ukwengeza imojula ye-tds_fdw ukuze kube lula ukufuduka ku-MS SQL Server.
- Ukusekelwa okusemthethweni kwamaphrosesa we-Elbrus.
Source: opennet.ru