Postgres Professional tau tshaj tawm tias muaj ib tus tswv cuab DBMS Pro Enterprise 15.1.1, raws li PostgreSQL 15 code puag thiab suav nrog cov yam ntxwv tshiab uas tau hloov pauv rau kev koom ua ke rau hauv cov ceg tom ntej ntawm PostgreSQL, nrog rau ntau qhov tshwj xeeb ntxiv rau siab- load systems. DBMS txhawb multimaster replication, thaiv-theem cov ntaub ntawv compression, incremental backup, built-in kev twb kev txuas pooler, optimized rooj partitioning, txhim kho tag nrho cov ntawv tshawb fawb, tsis siv neeg query compilation thiab teem sij hawm.
Main innovations:
- Kev them nyiaj yug rau pob khoom (Packages, teeb tsa cov haujlwm thiab cov txheej txheem) hauv cov qauv ntawm Oracle kom yooj yim rau kev tsiv teb tsaws ntawm PL/SQL code thaum tsiv ntawm Oracle mus rau Postgres. Los ntawm ib qho kev pom zoo, kev txhawb nqa pob yog qhov txuas ntxiv ntawm cov syntax ntawm PL / pgSQL lus (nrog me me ntxiv rau DBMS kernel), ua tsaug rau qhov kev ua haujlwm zoo ntawm Oracle pob khoom siv thiab ntau cov lus txib ntxiv tau qhia. rau kev ua haujlwm nrog lawv.
- Dhau qhov kev txwv tsis pub dhau mus rau ib tsab ntawv hauv psql, uas tso cai rau koj los tsim cov ntawv hloov pauv tau yooj yim dua thiab thoob ntiaj teb rau kev ua haujlwm nrog DBMS. Ntxiv rau qhov pom tseeb qhov zoo thaum tsim cov ntawv sau tshiab, qhov no yuav ua kom yooj yim rau kev hloov pauv ntawm SQL scripts thaum tsiv los ntawm Oracle DBMS, qhov kev ua haujlwm zoo li no paub rau tus neeg siv.
- Lub pgpro_anonymizer txuas ntxiv rau daim npog ntsej muag (obfuscation) ntawm cov ntaub ntawv, uas tso cai rau koj kom muaj kev ruaj ntseg ntawm cov ntaub ntawv khaws cia hauv kev lag luam-theem systems, nrog rau tsim cov ntawv theej tsis qhia npe ntawm cov ntaub ntawv siv rau hauv kev sim thiab kev txhim kho ib puag ncig.
- Raws li pg_probackup, ib qho khoom siv thaub qab tshiab rau kev lag luam ib puag ncig, pg_probackup Enterprise, tau tsim, uas siv: ib qho tshiab I / O subsystem uas nce kev ua tau zoo; kev txhawb nqa rau S3 raws tu qauv rau khaws cov ntaub ntawv hauv huab tshuab; compatibility ntawm CFS (cov ntaub ntawv compression) nrog lub mechanism rau tsim incremental backups; kev txhawb nqa rau txhua hom thaub qab (DELTA, PAGE thiab PTRACK); txhawb LZ4 thiab ZSTD compression algorithms.
- Tshiab JSON ua cov yam ntxwv los ntawm SQL: 2016 tus qauv ntxiv rau cov lus siv yav dhau los JSONPATH.
- Npaj ua haujlwm nrog TimescaleDB txuas ntxiv (tom qab nws tus tsim tawm tau tshaj tawm kev txhawb nqa rau PostgreSQL 15).
- Ntxiv tds_fdw module kom yooj yim tsiv teb tsaws los ntawm MS SQL Server.
- Kev txhawb nqa rau Elbrus processors.
Tau qhov twg los: opennet.ru