Kamora selemo sa nts'etsopele, ho hatisitsoe lekala le lecha le tsitsitseng la PostgreSQL 15 DBMS. Lintlafatso tsa lekala le lecha li tla lokolloa nakong ea lilemo tse hlano ho fihlela ka Pulungoana 2027.
Litlhahiso tse ka sehloohong:
- Tšehetso e ekelitsoeng bakeng sa taelo ea SQL "MERGE", e ts'oanang le poleloana "INSERT ... ON CONFLICT". MERGE e o lumella ho etsa lipolelo tsa SQL tse nang le maemo tse kopanyang ts'ebetso ea INSERT, UPDATE, le DELETE ho polelo e le 'ngoe. Ka mohlala, ka ho sebelisa MERGE, o ka kopanya litafole tse peli ka ho kenya lirekoto tse sieo le ho ntlafatsa tse teng. MERGE IN Customer_account ca USING recently_transactions t t.customer_id = ca.customer_id HA E TŠOANTŠWA U FETOTSA SET balance = balance + transaction_value HA E SA TŠOANTŠE HA E SA TŠOANTŠWE KE SEBELISA (customer_id, balance) VALUES (t.customer_id, t.customer_id);
- Li-algorithms tsa ho hlophisa data mohopolong le ho disk li ntlafalitsoe haholo. Ho latela mofuta oa data, liteko li bonts'a keketseho ea lebelo la ho hlopha ho tloha ho 25% ho isa ho 400%.
- Mesebetsi ea lifensetere e sebelisang row_number(), rank(), dense_rank() le count() e potlakisitsoe.
- Monyetla oa ho etsa lipotso ka mokhoa o ts'oanang le poleloana "KHETHA DISTINCT" e kentsoe ts'ebetsong.
- Mochini oa ho hokahanya litafole tsa kantle tsa kantle ho naha Wrapper (postgres_fdw) o sebelisa ts'ehetso bakeng sa boitlamo ba asynchronous ho kenyelletsa bokhoni bo kentsoeng pele ba ho sebetsana le likopo ho li-server tsa kantle.
- E ekelitse bokhoni ba ho sebelisa LZ4 le Zstandard (zstd) algorithms ho hatella li-log tsa transaction tsa WAL, tseo, tlas'a mesebetsi e meng, li ka ntlafatsang ka nako e le 'ngoe le ho boloka sebaka sa disk. Ho fokotsa nako ea ho hlaphoheloa ka mor'a ho hloleha, ho kenyelelitsoe tšehetso bakeng sa ho khutlisa maqephe a hlahang ho WAL log.
- Ts'ebeliso ea pg_basebackup e ekelitse ts'ehetso bakeng sa compression ea lehlakore la seva ea lifaele tsa backup o sebelisa mekhoa ea gzip, LZ4 kapa zstd. Hoa khoneha ho sebelisa li-module tsa hau bakeng sa ho boloka, ho u lumella ho etsa ntle le tlhoko ea ho tsamaisa litaelo tsa likhetla.
- Letoto la mesebetsi e mecha e kentsoe bakeng sa ho sebetsa likhoele ho sebelisoa lipolelo tse tloaelehileng: regexp_count(), regexp_instr(), regexp_like() le regexp_substr().
- Bokhoni ba ho kopanya mefuta ea mefuta e mengata ("multirange") bo kentsoe tšebetsong ea range_agg().
- Mokhoa o kentsoeng oa security_invoker, o u lumellang hore u thehe lipono tse sebetsang joalo ka mosebelisi ea letsetsang ho fapana le moetsi oa pono.
- Bakeng sa ho pheta-pheta ka mokhoa o utloahalang, tšehetso e kentsoe tšebetsong bakeng sa ho sefa mela le ho hlakisa manane a likholomo, e leng ho lumellang lehlakore la moromeli ho khetha karoloana ea data ho tsoa tafoleng bakeng sa ho ikatisetsa. Ntle le moo, mofuta o mocha o nolofatsa taolo ea likhohlano, mohlala, joale hoa khoneha ho tlola litšebelisano tse hanyetsanang le ho tima peeletso ka bo eona ha phoso e fumanoa. Ho pheta-pheta ka mokhoa o utloahalang ho lumella tšebeliso ea likarolo tse peli (2PC).
- Ho kentsoe sebopeho se secha sa log - jsonlog, se bolokang tlhahisoleseling ka sebopeho se hlophisitsoeng se sebelisa sebopeho sa JSON.
- Mookameli o na le bokhoni ba ho abela basebelisi litokelo tsa motho ka mong ho fetola maemo a itseng a tlhophiso ea seva ea PostgreSQL.
- Ts'ebeliso ea psql e ekelitse ts'ehetso ea ho batla tlhahisoleseling mabapi le litlhophiso (pg_settings) ho sebelisa taelo ea "\dconfig".
- Tšebeliso ea memori e arolelanoang e netefalitsoe bakeng sa ho bokella lipalo-palo mabapi le ts'ebetso ea seva, e leng se etsang hore ho khonehe ho tlosa mokhoa o fapaneng oa ho bokella lipalo-palo le nako le nako ho tsosolosa boemo ho disk.
- Bokhoni ba ho sebelisa libaka tsa kamehla tsa ICU "ICU Collation" bo fanoe; pele, ke libaka tsa libc feela tse neng li ka sebelisoa e le sebaka sa kamehla.
- Ho entsoe tlhahiso ea katoloso ea pg_walinspect, e u lumellang hore u hlahlobe litaba tsa lifaele ka lintlha tsa WAL u sebelisa lipotso tsa SQL.
- Bakeng sa schema ea sechaba, basebelisi bohle, ntle le mong'a database, ba bile le matla a ho phethahatsa taelo ea CREATE e hlakotsoe.
- Ts'ehetso ea Python 2 e tlositsoe ho PL/Python. Mokhoa oa ho boloka o neng o sa sebetse o tlositsoe.
Ho phaella: Ho tloha 19: 00 ho 20: 00 (MSK) ho tla ba le webinar e buang ka liphetoho tsa phetolelo e ncha le Pavel Luzanov (Postgres Professional). Bakeng sa ba sa khoneng ho kenela phatlalatso, ho rekota tlaleho ea Pavel ea June "PostgreSQL 15: MERGE le ho feta" ho PGConf.Russia e bulehile.
Source: opennet.ru