Mushure rinenge gore rekuvandudza, kusunungurwa kwe iro idzva rakatsiga bazi re PostgreSQL 13, iyo inosimbisa kuita kwepamusoro, pamwe nekubatanidzwa kwezvinhu zvitsva.
Kune avo vachiri kusaziva PostgreSQL, iwe unofanirwa kuziva kuti inozivikanwa zvakare sePostgres uye iyi ihukama hwehukama manejimendi manejimendi (RDBMS) yemahara, yakavhurwa sosi, iyo inotarisira kupa dhatabhesi inoenderana nekuwedzera uye kuteedzera nehunyanzvi zviyero.
Iyo yakagadzirirwa kubata akasiyana siyana ebasa, kubva pamachina akareruka kuenda kumatura edata kana masevhisi ewebhu nevashandisi vazhinji panguva imwe chete.
Chii chitsva muPostgreSQL 13?
Mune iyi vhezheni nyowani zvakasimbiswa izvo rekodhi kudzikiswa kwakaitwa muB-miti indexes, inogonesa yakawedzera query mashandiro uye yakadzora dhisiki nzvimbo yekushandisa kana uchinongedza marekodhi ane duplicate dhata.
Kunyengera kunoitwa nekupota uchimisikidza mutyairi iyo inosanganisa mapoka ezvinyorwa zvakapetwa uye inotsiva zvakapetwa zvine mareferenzi kune imwechete yakachengetwa kopi.
Uyezve zvakare mashandiro akanaka emibvunzo uchishandisa akaunganidzwa mabasa anosimbiswa, akaiswa maseti (GROUPING SETS) kana akapatsanurwa matafura (partitsirovannye).
Optimizations inoenderana nekushandiswa kweheshes mukuwedzera pane iyo chaiyo data, iyo inodzivirira kuisa iyo data rese mundangariro kana uchigadzirisa mibvunzo mikuru. Kupatsanura kwakawedzera huwandu hwemamiriro ezvinhu umo zvikamu zvinogona kubviswa kana kubatanidzwa.
Tambien akawedzera kugona kushandisa manhamba epamberi inogadzirwa nemurairo «Gadzira STATISTICS»Kuvandudza kushanda kwemubvunzo kuronga iine "OR" zvikamu kana zvinyorwa zvekutsvaga zvinoshandisa "IN" kana "ANY" zvikamu.
Index yekuchenesa panguva yekushanda VACUUM inomhanyisa nekuda kwekuunganidzwa kwemarara mune indices. Iine paramende nyowani «PARARLELE»Mutungamiri anogona kutsanangura huwandu hweshinda dzinozotangwa panguva imwe chete ku VACUUM.
Wakawedzera rutsigiro rwekuwedzera kurongedza, izvo zvinokutendera iwe kuti ushandise iyo data yakarongedzwa mudanho repamberi kuti ikurumidze kurongedza mune anotevera matanho ekukumbira kugadzirisa.
Kugonesa kugadzirisa kutsva, murongi wemubvunzo unopa marongero » inogonesa_incremental_sort ', Iyo inogoneswa nekutadza.
Wakawedzera kugona kudzikisira saizi yekudzokorora slots, iyo inobvumidza iwe kuti zvinyatso kuvimbisa kuchengetwa kwekunyora-kuseri kwelog (WAL) zvikamu kudzamara zvave kugamuchirwa neese akamira maseva anogashira replicas. Dzokororo inodzora zvakare inodzivirira iyo yekutanga server kubva mukudzima mitsara, iyo inogona kukonzeresa kukakavara kunyangwe kana yechipiri server isina internet.
De dzimwe shanduko dzinobuda pachena yeiyi vhezheni itsva:
- Parameter max_slot_wal_keep_size ikozvino inogona kushandiswa kudzikamisa saizi yakakura yefaira reWAL kudzivirira kubuda kunze kwediski nzvimbo.
- Mikana yekutarisa chiitiko cheDBMS inowedzerwa: mumurairo DZIDZA, kuratidzwa kwehuwandu hwakawanda pamusoro pekushandiswa kweWAL-log kunopihwa.
- Mutemo mutsva wawedzerwa pg_verifybackup kuongorora kutendeseka kwema backups akagadzirwa nemurairo pg_basebackup.
- Paunenge uchishanda naJSON uchishandisa vashandisi jsonpath, inobvumidzwa kushandisa basa nguva () kushandura mafomati enguva (ISO 8601 tambo uye yemuno PostgreSQL nguva mhando).
- Yakavakirwa-mukati basa rakawedzerwa gen_random_uuid () kugadzira UUID v4.
Iyo yekuparadzanisa sisitimu inopa yakazara rutsigiro rwekunzwisisa kudzokorora uye PASI pacho mutsara-nhanho zvinokonzeresa - Pfungwa yekuwedzeredzwa yakavimbika yaitwa, iyo inogona kuiswa nevashandisiwo zvavo vasina DBMS maneja kodzero.
- Rondedzero yemapulagini iyi yakatsanangurwa kare uye inogona kuwedzerwa neyemushandisi mushandisi. Anovimbwa plugins anosanganisira pgcrypto, tafurafunc, hstore, nezvimwe.
- Tafura yekunze inobatanidza mashandiro eiyo ekunze data mudziyo (postgres_fdw) inotsigira chitupa-chakavimbika.
Chekupedzisira, zvinonzi izvo zvidzoreso zvebazi idzva zvichaburitswa kwemakore mashanu kusvika Mbudzi 2025.
mabviro: https://www.postgresql.org/