Pambuyo pa chaka cha chitukuko, nthambi yatsopano yokhazikika ya PostgreSQL 15 DBMS yasindikizidwa. Zosintha za nthambi yatsopanoyi zidzatulutsidwa kwa zaka zisanu mpaka November 2027.
Zatsopano zazikulu:
- Thandizo lowonjezera la lamulo la SQL "MERGE", lomwe limafanana ndi mawu oti "INSERT ... ON CONFLICT". MERGE imakulolani kuti mupange mawu okhazikika a SQL omwe amaphatikiza INSERT, UPDATE, ndi DELETE ntchito m'mawu amodzi. Mwachitsanzo, pogwiritsa ntchito MERGE, mukhoza kuphatikiza matebulo awiri poika zolemba zomwe zikusowa ndikusintha zomwe zilipo kale. GWANIZANI KUKHALA MAKHALASI OGWIRITSA NTCHITO posachedwapa t.customer_id = ca.customer_id PAMENE ZIKULUMIKIZANA KENAKO KONZANI SET balance = ndalama zonse + transaction_value PAKASAGWIRIZANA NDIPO AYIWANI (customer_id, balance) VALUES (t.customer_id_id);
- Ma algorithms osankha deta mu kukumbukira ndi pa disk asinthidwa kwambiri. Kutengera mtundu wa data, mayeso akuwonetsa kuwonjezeka kwa liwiro la kusanja kuchokera ku 25% mpaka 400%.
- Ntchito zamawindo pogwiritsa ntchito row_number(), rank(), dense_rank() ndi count() zafulumizitsidwa.
- Kuthekera kwa mafunso ofananirako ndi mawu akuti "SELECT DISTINCT" kwakhazikitsidwa.
- Njira yolumikizira matebulo akunja a Foreign Data Wrapper (postgres_fdw) imagwiritsa ntchito chithandizo cha ma asynchronous commits kuwonjezera pa luso lomwe lawonjezeredwa kale kuti likonze zopempha kumaseva akunja.
- Anawonjezera luso logwiritsa ntchito ma algorithms a LZ4 ndi Zstandard (zstd) kuti akanikizire zipika za WAL, zomwe, pansi pa ntchito zina, zimatha kusintha nthawi imodzi ndikusunga malo a disk. Kuti muchepetse nthawi yochira pambuyo pa kulephera, chithandizo cha kubweza mwachangu masamba omwe akuwonekera mu chipika cha WAL awonjezedwa.
- Pulogalamu ya pg_basebackup yawonjezera kuthandizira kwa seva-mbali yamafayilo osunga zosunga zobwezeretsera pogwiritsa ntchito njira za gzip, LZ4 kapena zstd. Ndizotheka kugwiritsa ntchito ma module anu posungira, kukulolani kuchita popanda kufunikira koyendetsa malamulo a zipolopolo.
- Ntchito zingapo zatsopano zawonjezedwa pokonza zingwe pogwiritsa ntchito mawu okhazikika: regexp_count(), regexp_instr(), regexp_like() ndi regexp_substr().
- Kutha kuphatikizira mitundu yosiyanasiyana ("multirange") kwawonjezedwa ku range_agg() ntchito.
- Njira yowonjezera chitetezo_invoker, yomwe imakupatsani mwayi wopanga mawonedwe omwe amayenda ngati woyimbira foni m'malo mopanga mawonekedwe.
- Pakubwereza momveka bwino, kuthandizira pakusefa mizere ndi kutchula mndandanda wa zigawo zakhazikitsidwa, zomwe zimathandiza kumbali ya wotumiza kusankha kagawo kakang'ono ka deta patebulo kuti abwerezenso. Kuphatikiza apo, mtundu watsopanowu umathandizira kuwongolera kusamvana, mwachitsanzo, ndizotheka kulumpha zochitika zosemphana ndikuyimitsa kulembetsa pomwe cholakwika chazindikirika. Kubwereza koyenera kumalola kugwiritsa ntchito magawo awiri (2PC).
- Mtundu watsopano wa chipika wawonjezedwa - jsonlog, womwe umasunga zidziwitso mu mawonekedwe opangidwa pogwiritsa ntchito mtundu wa JSON.
- Woyang'anira ali ndi mphamvu yopereka ufulu wa munthu aliyense kwa ogwiritsa ntchito kuti asinthe magawo ena a seva ya PostgreSQL.
- Chida cha psql chawonjezera thandizo pakufufuza zambiri pazosintha (pg_settings) pogwiritsa ntchito lamulo la "\dconfig".
- Kugwiritsiridwa ntchito kwa kukumbukira kogawana kumatsimikiziridwa kuti muwonjezere ziwerengero za ntchito ya seva, zomwe zimapangitsa kuti zitheke kuchotsa njira yosiyana yosonkhanitsa ziwerengero ndikubwezeretsanso boma ku disk nthawi ndi nthawi.
- Kutha kugwiritsa ntchito madera okhazikika a ICU "ICU Collation" kwaperekedwa; m'mbuyomu, malo a libc okha ndi omwe angagwiritsidwe ntchito ngati malo osakhazikika.
- Pulogalamu yowonjezera pg_walinspect yaperekedwa, yomwe imakulolani kuti muyang'ane zomwe zili m'mafayilo okhala ndi zipika za WAL pogwiritsa ntchito mafunso a SQL.
- Kwa schema yapagulu, ogwiritsa ntchito onse, kupatula eni ake a database, ali ndi ulamuliro wopereka lamulo la CREATE lochotsedwa.
- Chithandizo cha Python 2 chachotsedwa mu PL/Python.
Kuwonjezera: Kuchokera ku 19: 00 mpaka 20: 00 (MSK) padzakhala webinar kukambirana za kusintha kwa Baibulo latsopano ndi Pavel Luzanov (Postgres Professional). Kwa iwo omwe sangathe kulowa nawo pawayilesi, kujambula kwa lipoti la Pavel la June "PostgreSQL 15: MERGE ndi zina" pa PGConf.Russia ndi lotseguka.
Source: opennet.ru