Tom qab ib xyoos ntawm kev txhim kho, ib ceg ruaj khov tshiab ntawm PostgreSQL 15 DBMS tau tshaj tawm. Kev hloov tshiab rau ceg tshiab yuav raug tso tawm ntau tshaj tsib xyoos txog rau lub Kaum Ib Hlis 2027.
Main innovations:
- Ntxiv kev txhawb nqa rau SQL hais kom ua "MERGE", uas zoo li cov lus qhia "INSERT ... ON CONFLICT". MERGE tso cai rau koj los tsim cov nqe lus SQL raws cai uas muab INSERT, Hloov Kho, thiab DELETE cov haujlwm rau hauv ib qho kev qhia. Piv txwv li, siv MERGE, koj tuaj yeem ua ke ob lub rooj los ntawm kev ntxig cov ntaub ntawv uas ploj lawm thiab hloov kho cov uas twb muaj lawm. UA HAUJ LWM INTO customer_account ca USING recent_transactions t ON t.customer_id = ca.customer_id Thaum MATCHED TAM SIM NO SET tshuav = tshuav nyiaj li cas + muas_value THAUM TSIS TAU TXAIS (customer_id, tshuav nyiaj li cas) VALUES (t.customer_id, value.
- Algorithms rau sorting cov ntaub ntawv nyob rau hauv lub cim xeeb thiab nyob rau hauv disk tau zoo heev. Nyob ntawm seb hom ntaub ntawv, cov kev ntsuam xyuas qhia tau tias muaj kev nce hauv kev sib tw ceev ntawm 25% mus rau 400%.
- Lub qhov rais ua haujlwm siv row_number(), rank(), dense_rank() thiab suav() tau nrawm dua.
- Qhov ua tau ntawm kev ua tiav ntawm cov lus nug nrog cov lus qhia "SELECT DISTINCT" tau ua tiav.
- Lub tshuab rau kev sib txuas cov rooj sab nraud Txawv Teb Chaws Cov Ntaub Ntawv Wrapper (postgres_fdw) siv kev txhawb nqa rau asynchronous commits ntxiv rau yav tas los ntxiv peev xwm rau asynchronously txheej txheem thov rau lwm servers.
- Ntxiv qhov muaj peev xwm siv LZ4 thiab Zstandard (zstd) algorithms los nthuav WAL cov ntawv teev npe, uas, nyob rau hauv qee qhov kev ua haujlwm, tuaj yeem txhim kho kev ua tau zoo thiab txuag chaw disk. Txhawm rau txo lub sijhawm rov qab los tom qab ua tsis tiav, kev txhawb nqa rau kev rov qab tau cov nplooj ntawv tshwm sim hauv WAL lub cav tau ntxiv.
- Cov khoom siv pg_basebackup tau ntxiv kev txhawb nqa rau server-sab compression ntawm cov ntaub ntawv thaub qab siv gzip, LZ4 lossis zstd txoj kev. Nws muaj peev xwm siv koj tus kheej modules rau archiving, tso cai rau koj ua yam tsis tas yuav tsum tau khiav lub plhaub commands.
- Ib txoj haujlwm tshiab tau ntxiv rau kev ua cov hlua uas siv cov kab lus tsis tu ncua: regexp_count(), regexp_instr(), regexp_like() thiab regexp_substr().
- Lub peev xwm los sib sau ua ke ntau hom ("multirange") tau ntxiv rau qhov range_agg() muaj nuj nqi.
- Ntxiv security_invoker hom, uas tso cai rau koj los tsim cov kev xav uas khiav raws li tus neeg siv hu es tsis yog tus tsim saib.
- Rau cov ntaub ntawv rov ua dua tshiab, kev txhawb nqa rau kev lim cov kab thiab kev qhia cov npe ntawm kab tau raug siv, tso cai rau ntawm tus neeg xa khoom los xaiv ib pawg ntawm cov ntaub ntawv los ntawm lub rooj rau replication. Tsis tas li ntawd, tus tshiab version ua kom yooj yim rau kev tswj hwm kev tsis sib haum xeeb, piv txwv li, tam sim no nws muaj peev xwm hla kev tsis sib haum xeeb thiab tuaj yeem kaw qhov kev tso npe thaum pom qhov yuam kev. Logical replication tso cai rau siv ob-theem commits (2PC).
- Ib hom ntawv cav tshiab tau ntxiv - jsonlog, uas txuag cov ntaub ntawv hauv ib daim ntawv uas siv JSON hom.
- Tus thawj tswj hwm muaj peev xwm xa cov cai ntawm tus kheej rau cov neeg siv los hloov qee qhov PostgreSQL server configuration tsis.
- Cov khoom siv psql tau ntxiv kev txhawb nqa rau kev tshawb nrhiav cov ntaub ntawv hais txog kev teeb tsa (pg_settings) siv "\dconfig" hais kom ua.
- Kev siv lub cim xeeb sib koom tau ua kom ntseeg tau rau kev khaws cov txheeb cais txog kev ua haujlwm ntawm cov neeg rau zaub mov, uas ua rau nws muaj peev xwm tshem tawm cov txheej txheem sib cais ntawm kev sau cov txheeb cais thiab ncua sijhawm rov pib lub xeev rau disk.
- Lub peev xwm los siv lub neej ntawd ICU thaj chaw "ICU Collation" tau muab; yav dhau los, tsuas yog libc thaj chaw tuaj yeem siv los ua qhov chaw nyob.
- Ib qho kev txuas ntxiv hauv pg_walinspect tau raug npaj, uas tso cai rau koj los tshuaj xyuas cov ntsiab lus ntawm cov ntaub ntawv nrog WAL cov cav siv SQL queries.
- Rau cov pej xeem schema, txhua tus neeg siv, nrog rau kev zam ntawm tus tswv database, tau muaj lawv txoj cai los ua CREATE hais kom tshem tawm.
- Kev them nyiaj yug rau Python 2 tau raug tshem tawm hauv PL / Python. Qhov tsis siv neeg thaub qab hom tau raug tshem tawm.
Ntxiv: Los ntawm 19:00 txog 20:00 (MSK) yuav muaj lub vev xaib sib tham txog cov kev hloov pauv hauv cov ntawv tshiab nrog Pavel Luzanov (Postgres Professional). Rau cov neeg uas tsis tuaj yeem koom nrog kev tshaj tawm, sau tseg ntawm Pavel lub Rau Hli tsab ntawv ceeb toom "PostgreSQL 15: MERGE thiab ntau dua" ntawm PGConf.Russia qhib.
Tau qhov twg los: opennet.ru