Postgres Professional yalengeza za kupezeka kwa eni ake a DBMS Pro Enterprise 15.1.1, kutengera PostgreSQL 15 code base komanso zinthu zatsopano zomwe zimasamutsidwa kuti ziphatikizidwe m'magawo otsatirawa a PostgreSQL, komanso zina zingapo zowonjezera zapamwamba- katundu machitidwe. DBMS imathandizira kubwereza kwa ma multimaster, kuphatikizika kwa data pa block-level, kusungitsa zosunga zobwezeretsera, cholumikizira cholumikizira, kugawa bwino patebulo, kusaka kwamalemba athunthu, kuphatikizika kwamafunso ndikukonzekera.
Zatsopano zazikulu:
- Thandizo la phukusi (Maphukusi, ma seti a ntchito ndi njira) mumayendedwe a Oracle kuti muchepetse kusamuka kwa code ya PL/SQL mukachoka ku Oracle kupita ku Postgres. Kuchokera pamalingaliro aukadaulo, kuthandizira phukusi ndikukulitsa mawu a chilankhulo cha PL/pgSQL (ndi zoonjezera zazing'ono ku DBMS kernel), chifukwa chake analogue yogwira ntchito ya phukusi la Oracle imayendetsedwa ndipo malamulo angapo owonjezera amayambitsidwa. kuti agwire nawo ntchito.
- Kupititsa magawo okhazikika ku script mu psql, yomwe imakupatsani mwayi wopanga zolemba zosinthika komanso zapadziko lonse lapansi zogwirira ntchito ndi DBMS. Kuphatikiza pa zabwino zodziwikiratu popanga zolemba zatsopano, izi zimathandizira kusintha kwa zolemba za SQL mukasamuka kuchokera ku Oracle DBMS, komwe magwiridwe antchitowa amadziwika kwa wogwiritsa ntchito.
- Kukula kwa pgpro_anonymizer kwa masking (obfuscation) ya data, yomwe imakulolani kuti muwonetsetse chitetezo cha kusungidwa kwa data mu machitidwe amakampani, komanso kupanga makope osadziwika a database kuti agwiritsidwe ntchito poyesa ndi chitukuko.
- Kutengera pg_probackup, chida chatsopano chosunga zobwezeretsera m'malo amakampani, pg_probackup Enterprise, yapangidwa, yomwe imagwiritsa ntchito: kachitidwe katsopano ka I/O komwe kumawonjezera magwiridwe antchito; kuthandizira kwa protocol ya S3 yosungira deta mumtambo; kuyanjana kwa CFS (kuponderezedwa kwa data) ndi njira yopangira zosunga zobwezeretsera; chithandizo chamitundu yonse yosunga zobwezeretsera (DELTA, PAGE ndi PTRACK); kuthandizira kwa LZ4 ndi ZSTD compression algorithms.
- Zatsopano za JSON zosinthidwa kuchokera ku SQL: muyezo wa 2016 kuwonjezera pa chilankhulo cha JSONPATH chomwe chinakhazikitsidwa kale.
- Wokonzeka kugwira ntchito ndi kukulitsa kwa TimescaleDB (pamene wopanga adalengeza movomerezeka thandizo la PostgreSQL 15).
- Kuwonjezera gawo la tds_fdw kuti muchepetse kusamuka kuchokera ku MS SQL Server.
- Thandizo lovomerezeka la Elbrus processors.
Source: opennet.ru