Professionalwararriyar Postgres ta sanar da kasancewar Pro Enterprise 15.1.1 DBMS na mallakar ta, dangane da tushen lambar PostgreSQL 15 kuma gami da sabbin fasalulluka waɗanda aka canjawa wuri don haɗawa cikin rassan PostgreSQL masu zuwa, kazalika da adadin takamaiman ƙari don babban- lodi tsarin. DBMS yana goyan bayan kwafi-mafi-mafi-mafi yawa, toshe-matakin bayanai na toshewa, ƙarin tallafi, ginanniyar haɗin haɗin kai, ingantaccen ɓangaren tebur, ingantaccen bincike mai cikakken rubutu, haɗar tambaya ta atomatik da tsara tsari.
Manyan sabbin abubuwa:
- Taimako don fakitin salon Oracle (Packages, saitin ayyuka da matakai) don sauƙaƙe ƙaura na lambar PL/SQL lokacin ƙaura daga Oracle zuwa Postgres. Daga ra'ayi na fasaha, goyon bayan fakitin haɓakawa ne na haɗin harshe na PL / pgSQL (tare da ƙananan ƙari ga ainihin DBMS), godiya ga wanda aka aiwatar da aikin analog na fakitin Oracle kuma an gabatar da ƙarin ƙarin umarni don aiki. tare da su.
- Wuce madaidaicin matsayi zuwa rubutun a cikin psql, wanda ke ba ku damar ƙirƙirar mafi sassauƙa da madaidaitan rubutun harsashi don aiki tare da DBMS. Baya ga fa'idodin bayyane lokacin zana sabbin rubutun, wannan zai sauƙaƙa daidaita rubutun SQL lokacin ƙaura daga Oracle DBMS, inda irin wannan aikin ya saba da mai amfani.
- Tsawaita pgpro_anonymizer don rufe bayanan (obfuscation), wanda ke ba ku damar tabbatar da amincin ma'ajiyar bayanai a cikin tsarin matakin kamfanoni, da ƙirƙirar kwafin bayanan bayanan da ba a bayyana ba don amfani da su a cikin gwaji da mahallin ci gaba.
- Dangane da pg_probackup, an ɓullo da sabon kayan aiki na madadin don mahalli na kamfani pg_probackup Enterprise, wanda ke aiwatar da: sabon tsarin I / O wanda ke haɓaka aiki; goyon baya ga yarjejeniyar S3 don adana bayanai a cikin tsarin girgije; daidaitawar CFS (matsawar bayanai) tare da tsarin ƙirƙirar madadin haɓakawa; goyan bayan duk yanayin wariyar ajiya (DELTA, PAGE da PTRACK); goyan bayan LZ4 da ZSTD matsawa algorithms.
- Sabbin ayyukan sarrafa JSON daga SQL: mizanin 2016 ban da harshen JSONPATH da aka aiwatar a baya.
- Shirye don aiki tare da tsawo na TimescaleDB (bayan sanarwar hukuma ta mai haɓakawa game da tallafin PostgreSQL 15).
- Ƙara tsarin tds_fdw don sauƙaƙe ƙaura daga MS SQL Server.
- Taimako na hukuma don masu sarrafawa na Elbrus.
source: budenet.ru