Mushure megore rekuvandudzwa, bazi idzva rakatsiga rePostgreSQL 15 DBMS raburitswa. Zvigadziriso zvebazi idzva zvichaburitswa kwemakore mashanu kusvika Mbudzi 2027.
Zvitsva zvikuru:
- Yakawedzerwa tsigiro yemurairo weSQL "MERGE", iyo yakafanana neshoko rekuti "INSERT ... PAKUKANGANANA". MERGE inokutendera iwe kuti ugadzire zvine zvirevo zveSQL zvinosanganisa INSERT, UPDATE, uye DELETE mashandiro kuita kutaura kumwe chete. Semuenzaniso, uchishandisa MERGE, unogona kubatanidza matafura maviri nekuisa marekodhi asipo uye nekuvandudza aripo. KUBATSIRAI MUcustomer_account ca USING recent_transactions t t.customer_id = ca.customer_id KANA WAKUFANISA UZOSIMBISA SET balance = balance + transaction_value KANA ZVISINA KUENDERANA WOISA (customer_id, balance) ZVINOKOSHA (t.customer_id, t.customer_id);
- Algorithms ekugadzirisa data mundangariro uye padhisiki yakagadziridzwa zvakanyanya. Zvichienderana nerudzi rwe data, bvunzo dzinoratidza kuwedzera kwekuronga kumhanya kubva pa25% kusvika 400%.
- Mahwindo emabasa anoshandisa row_number(), chinzvimbo(), dense_rank() uye count() yakamhanyiswa.
- Iko mukana wekuita zvakafanana kwemibvunzo ine chirevo chekuti "SELECT DISTINCT" yaitwa.
- Iyo nzira yekubatanidza matafura ekunze Kunze Dhata Wrapper (postgres_fdw) inoshandisa tsigiro yeasynchronous anoita mukuwedzera kune yakambowedzerwa kugona kuita asynchronously kuita zvikumbiro kune ekunze maseva.
- Yakawedzera kugona kushandisa LZ4 uye Zstandard (zstd) algorithms kumanikidza WAL transaction logs, iyo, pasi pemamwe mabasa, inogona panguva imwe chete kuvandudza mashandiro uye kuchengetedza disk nzvimbo. Kuti uderedze nguva yekudzoreredza mushure mekutadza, rutsigiro rwekudzoreredza kudzoreredza kwemapeji arikuonekwa mune WAL log yawedzerwa.
- Iyo pg_basebackup utility yakawedzera tsigiro yeserver-side compression yemafaira ekuchengetedza uchishandisa gzip, LZ4 kana zstd nzira. Izvo zvinogoneka kushandisa ako ega mamodule ekuchengetera, achikubvumidza iwe kuti uite pasina chikonzero chekumhanyisa shell mirairo.
- Nhevedzano yemabasa matsva akawedzerwa ekugadziridza tambo uchishandisa akajairwa mataurirwo: regexp_count(), regexp_instr(), regexp_like() uye regexp_substr().
- Iko kugona kuunganidza marudzi akawanda ("multirange") kwakawedzerwa kune range_agg () basa.
- Yakawedzera security_invoker modhi, iyo inokutendera iwe kuti ugadzire maonero anomhanya semushandisi wekufona kwete musiki wekuona.
- Kuti udzokorore zvine musoro, tsigiro yekusefa mitsetse uye rondedzero yemakoramu yaitwa, zvichibvumira kudivi reanotumira kusarudza chikamu chedata kubva patafura kuti chidzokororwe. Pamusoro pezvo, iyi vhezheni itsva inorerutsa kutonga kwekunetsana, semuenzaniso, zvave kugoneka kusvetuka kutengeserana kunopokana uye wotodzima kunyoreswa kana kukanganisa kwaonekwa. Kudzokorora kunonzwisisika kunobvumira kushandiswa kwezvikamu zviviri-chikamu (2PC).
- Iyo nyowani yelogi fomati yakawedzerwa - jsonlog, iyo inochengetedza ruzivo mune yakarongeka fomu uchishandisa iyo JSON fomati.
- Iye maneja ane kugona kugovera kodzero dzemunhu kune vashandisi kuti vachinje mamwe PostgreSQL sevha yekumisikidza paramita.
- Iyo psql utility yakawedzera rutsigiro rwekutsvaga ruzivo nezvezvirongwa (pg_settings) uchishandisa iyo "\dconfig" murairo.
- Iko kushandiswa kwekugovana ndangariro kunovimbiswa kuunganidza nhamba nezve mashandiro evhavha, izvo zvinoita kuti zvibvire kubvisa imwe nzira yekuunganidza nhamba uye nguva nenguva kugadzirisa nyika ku diski.
- Iko kugona kushandisa iyo yakasarudzika ICU nzvimbo "ICU Collation" yakapihwa; kare, libc chete nzvimbo dzaigona kushandiswa seyakasarudzika nzvimbo.
- Iyo yakavakirwa-mukati yekuwedzera pg_walinspect yakatsanangurwa, iyo inobvumidza iwe kuti uongorore zviri mukati memafaira ane WAL matanda uchishandisa SQL mibvunzo.
- Kune veruzhinji schema, vese vashandisi, kunze kwemuridzi wedhatabhesi, vakave nesimba ravo rekuita iyo CREATE murairo wakabviswa.
- Tsigiro yePython 2 yabviswa muPL/Python.
Kuwedzera: Kubva 19:00 kusvika 20:00 (MSK) pachava newebhunari inokurukura kuchinja kweshanduro itsva naPavel Luzanov (Postgres Professional). Kune avo vasingakwanise kujoina kutepfenyura, kurekodha kwePavel's June mushumo "PostgreSQL 15: MERGE uye nezvimwe" paPGConf.Russia yakavhurika.
Source: opennet.ru