PostgreSQL ndeye yakavhurika sosi chinhu-yakatarisana nehukama dhatabhesi manejimendi system.
Mushure megore rekuvandudza kuburitswa kwebazi idzva rakagadzikana reDBMS PostgreSQL 15 yakaziviswa, Kuburitswa uku kunosanganisira huwandu hwekuwedzera, kusanganisira hutsva hwekumanikidza hunobatsira nekuchengetedza data nekuchengetedza, kuvandudzwa kwekuronga data nekukurumidza kutarisa, uye kutsva matanda uye SQL kugona.
Mune iyi vhezheni itsva inoratidzwa, iyo SQL yekuraira "MERGE" inosimbiswa, , que inokubvumira kuti ugadzire zvinyorwa zveSQL izvo zvinosanganisa INSERT, UPDATE, uye DELETE mashandiro mune chirevo chimwe chete. Semuenzaniso, MERGE inogona kushandiswa kubatanidza matafura maviri nekuisa marekodhi asipo uye kugadzirisa aripo.
Kuraira inobvumira kubatanidza tafura uye inoita kuti PostgreSQL ienderane neSQL Server-based relational database manejimendi masisitimu, anosanganisira Microsoft SQL Server uye SAP ASE relational dhatabhesi server, uye chero mamwe anotsigira Transact-SQL suite yemapurogiramu ekuwedzera.
Imwe shanduko inomira pachena mune iyi vhezheni itsva ndeye mune maalgorithms ekugadzirisa data mundangariro uye padhisiki yakagadziridzwa zvakanyanya. Zvichienderana nerudzi rwe data mune bvunzo, pane kuwedzera kwekurongedza kumhanya kubva pa25% kusvika 400%.
Kuti udzokorore zvine musoro, tsigiro yekusefa mitsara uye kudoma mazita emakoramu anoitwa, iyo inobvumira, kudivi reanotumira, kusarudza subset yedata rekudzokorora kwetafura. Pamusoro pezvo, vhezheni iyi yakarerusa kutonga kwekunetsana, semuenzaniso kugona kusvetuka kutengeserana kunopokana uye nekuzvibvisa pachezvakunyoreswa kana kukanganisa kwaonekwa. Kudzokorodza kunonzwisisika kunobvumira kushandiswa kwezvikamu zviviri-chikamu (2PCs).
Iyo michina yekubatanidza ekunze matafura Ekunze data mudziyo (postgres_fdw) inoshandisa tsigiro yeasynchronous commits kuwedzera kune yakambowedzerwa kugona kugadzirisa zvikumbiro kune ekunze maseva asynchronously.
Yakawedzera kugona kushandisa iyo LZ4 uye Zstandard algorithms (zstd) kudzvanya WAL transaction logs, iyo, pasi pemamwe mabasa, inogona panguva imwe chete kunatsiridza mashandiro uye kuchengetedza dhisiki nzvimbo, uye yakawedzera tsigiro yekutsvagisa mapeji anoonekwa murogi yekutengeserana. WAL kuderedza kutadza kupora nguva.
Izvo zvakare zvakasimbiswa izvo yakawedzerwa kune pg_basebackup utility la rutsigiro rwekumanikidza mafaera ekuchengetedza padivi reseva uchishandisa gzip, LZ4, kana zstd nzira. Iko kugona kushandisa ako ega mamodule ekuchengetera kwakapihwa, izvo zvinokutendera kuti uparadze nekudiwa kwekumhanya mirairo yegomba.
Pamusoro peizvozvo, ikozvino muPostgreSQL 15 kushandiswa kwendangariro kwakagoverwa kwakasimbiswa kuunganidzwa kwenhamba pamusoro pekushanda kwevhavha, izvo zvakaita kuti zvibvirire kubvisa imwe nzira yekuunganidza nhamba uye nguva nenguva kushandura nyika kune disk.
Yeimwe shanduko dzinomira kubva mushanduro nyowani:
- Yakawedzera huwandu hwemabasa matsva ekugadzirisa tambo uchishandisa zvirevo zvenguva dzose: regexp_count(), regexp_instr(), regexp_like(), uye regexp_substr().
- Yakawedzera kugona kuwedzera akawanda-renji mhando ("multi-range") kune range_agg () basa.
Yakawedzera security_invoker modhi yekubvumira kugadzirwa kwemaonero anofamba nekodzero dzemushandisi arikukwezva, pane musiki wekuona. - Iyo nyowani yelogi fomati yakawedzerwa: jsonlog, iyo inochengetedza ruzivo nenzira yakarongeka uchishandisa iyo JSON fomati.
- Iye maneja ane kugona kugovera kodzero dzemunhu kune vashandisi kuti vachinje mamwe maPostgreSQL server kumisikidza paramita.
- Tsigiro yakawedzerwa kune iyo psql yekushandisa kutsvaga ruzivo nezve marongero (pg_settings) uchishandisa iyo "\ dconfig" murairo.
- Yakavakirwa-mukati pg_walinspect yekuwedzera yakakurudzirwa iyo inobvumidza iwe kuti uongorore zviri mukati memafaira ane WAL marekodhi uchishandisa SQL mibvunzo.
- Yakabviswa Python 2 rutsigiro muPL/Python
- Yakabviswa yakabviswa "exclusive backup" modhi.
- Iko mukana wekuita zvakafanana kwemibvunzo neshoko rekuti "SELECT DISTINCT" rinoitwa.
Pakupedzisira zvakakodzera kutaura izvozvo kuvandudzwa kwebazi idzva kuchabudiswa kwemakore mashanu kusvika munaNovember 2027. Kana iwe uchida kuziva zvakawanda nezvazvo, unogona kubvunza zvakadzama mu inotevera chinongedzo.