PostgreSQL 13 DBMS kuburitswa

Mushure megore rebudiriro rakabudiswa bazi idzva rakagadzikana reDBMS PostgreSQL 13. Zvigadziriso zvebazi idzva achabuda kwemakore mashanu kusvika munaNovember 2025.

chikuru zvitsva:

• Implemented deduplication zvinyorwa muB-tree indexes, izvo zvakaita kuti zvikwanise kuvandudza mashandiro emubvunzo uye kuderedza kushandiswa kwedhisiki nzvimbo paunenge uchinyora marekodhi ane duplicate data. Deduplication inoitwa kuburikidza nekuvhurwa nguva nenguva kwemubati anosanganisa mapoka eanodzokorora matuples uye anotsiva akadhindwa nemalink kune imwe yakachengetwa kopi.
• Kuvandudzwa kwekuita kwemibvunzo inoshandisa aggregate mabasa, mapoka akaiswa (GROUPING SETS) kana partitioned (akakamurwa) matafura. Optimizations inosanganisira kushandisa hashes pachinzvimbo che data chairo kana uchiunganidza, izvo zvinodzivirira kuisa data rese mundangariro paunenge uchigadzirisa mibvunzo mikuru. Pakuparadzanisa, huwandu hwemamiriro ezvinhu umo zvikamu zvinogona kuraswa kana kubatanidzwa zvakawedzerwa.
• Yakawedzera kugona kushandisa advanced statisticsyakagadzirwa nekushandisa iyo CREATE STATISTICS command yekuvandudza kurongeka kwemibvunzo ine OR mamiriro kana rondedzero yekutsvaga uchishandisa IN kana CHESE mataurirwo.
• Kucheneswa kwema indexes panguva yekushanda kwakakurumidza VACUUM nekufananidza kuunganidzwa kwemarara muma indexes. Uchishandisa iyo itsva "PARALLEL" parameter, maneja anogona kuona nhamba yeshinda inomhanya panguva imwe chete yeVACUUM. Yakawedzera kugona kwekutanga otomatiki VACUUM kuuraya mushure mekuisa data.
• Yakawedzerwa tsigiro yekuwedzera kurongedza, iyo inokutendera iwe kuti ushandise data rakarongwa pane yapfuura nhanho kuti ikurumidze kurongedza pane anotevera matanho ekugadzirisa mibvunzo. Kugonesa iyo nyowani optimization mumubvunzo kuronga, pane kuseta "inogonesa_incremental_sort", iyo inogoneswa neiyo default.
• Yakawedzera kugona kudzikamisa saizi kudzokorora slots, zvichikubvumidza kuti uzvisimbise otomatiki kuchengetedza kwekunyora-usimbe log (WAL) zvikamu kudzamara zvagamuchirwa nemasevha ekuchengetedza anogamuchira replicas. Replication slots zvakare inodzivirira sevha yekutanga kubva pakudzima mitsara inogona kukonzera kusawirirana, kunyangwe iyo backup server isiri pamhepo. Kushandisa parameter max_slot_wal_keep_size Iwe zvino unogona kudzikamisa saizi yepamusoro yemafaira eWAL kudzivirira kupera kwedhisiki nzvimbo.
• Unyanzvi hwekutarisa basa reDBMS rakawedzerwa: murairo we EXPLAIN unopa kuratidzwa kwehuwandu hwehuwandu hwekushandiswa kweWAL log; V pg_basebackup yakapa mukana wekutevera mamiriro ekuenderera mberi backups; Iyo ANALYZE command inopa chiratidzo chekufambira mberi kwebasa.
• Murairo mutsva wakawedzerwa pg_verifybackup kuti utarise kutendeseka kwema backups akagadzirwa neiyo pg_basebackup command.
• Paunenge uchishanda neJSON uchishandisa vashandisi jsonpath Inobvumira datetime() basa kuti rishandiswe kushandura mafomati enguva (ISO 8601 tambo nemhando dzenguva dzePostgreSQL). Semuenzaniso, unogona kushandisa zvivakwa "jsonb_path_query('["2015-8-1", "2015-08-12"]', '$[*] ? (@.datetime() < "2015-08-2" ".datetime ())')" uye "jsonb_path_query_array('["12:30", "18:40"]', '$[*].datetime("HH24:MI")')".
• Yakawedzerwa-yakavakirwa-mukati basa gen_random_uuid () kugadzira UUID v4.
• Iyo partitioning sisitimu inopa rutsigiro rwakazara rwekudzokorodza zvine musoro uye izvo zvinotsanangurwa ne "KUSATI" kutaura
  zvinokonzeresa zvinoshanda padanho remutsara.

• Syntax "tora TANGA" ikozvino inobvumira kushandiswa kwe "NE TIES" kutaura kudzosa mimwe mitsara iri pamuswe wemhedzisiro yakawanikwa mushure mekushandisa "ORDER BY".
• Yakaita pfungwa yeakavimbika ekuwedzera ("trusted extension"), iyo inogona kuiswa nevashandisiwo zvavo vasina kodzero yeDBMS yekutonga. Rondedzero yeakadaro ekuwedzera inofanotsanangurwa uye inogona kuwedzerwa neiyo superuser. Kuvimbika ma-add-ons anosanganisira pgcrypto, tablefunc, hstore uye zvakadaro.
• Iyo nzira yekubatanidza matafura ekunze Kunze Dhata Wrapper (postgres_fdw) inoshandisa tsigiro yekusimbisa-chitupa. Paunenge uchishandisa SCRAM kuvimbiswa, vatengi vanobvumidzwa kukumbira "channel binding"(chiteshi chinosunga).

Source: opennet.ru