ProHoster > Blog > internet nhau > PostgreSQL 12 kuburitswa

PostgreSQL 12 kuburitswa

Chikwata chePostgreSQL chakazivisa kuburitswa kwePostgreSQL 12, iyo yazvino vhezheni yeiyo yakavhurika sosi relational database management system.
PostgreSQL 12 yakavandudza zvakanyanya kuita kwemubvunzo - kunyanya kana ichishanda nemavhoriyamu makuru e data, uye yakagadzirisawo kushandiswa kwedhisiki nzvimbo mune zvese.

Zvitsva zvinosanganisira:

  • kushandiswa kweiyo JSON Path query mutauro (iyo inonyanya kukosha chikamu cheSQL/JSON standard);
  • optimization yekuitwa kweakajairwa tafura kutaura (WITH);
  • tsigiro yemakoramu anogadzirwa

Nharaunda zvakare inoramba ichishanda pakuwedzera uye kuvimbika kwePostgreSQL, kusimudzira rutsigiro rwekudyidzana nedzimwe nyika, kugona kwechokwadi, nekupa nzira dziri nyore dzekutonga hurongwa.

Kuburitswa uku kunosanganisira kusetwa kweiyo interface yeinjini yekuchengetera pluggable, iyo ikozvino inobvumira vanogadzira kuti vagadzire nzira dzavo dzekuchengetedza data.

Kuvandudzwa kwemaitiro

PostgreSQL 12 inosanganisira kwakakosha kuita uye kugadzirisa kugadzirisa kwe indexing uye partitioning masisitimu.

B-miti indekisi, iyo yakajairwa indexing mhando muPostgreSQL, yakagadziridzwa muvhezheni 12 yemabasa akawanda anosanganisira kazhinji indekisi kugadziridzwa. Kushandisa iyo TPC-C benchmark yePostgreSQL 12 yakaratidza avhareji ye40% kudzikiswa kwekushandiswa kwenzvimbo uye kuwedzera kwese kwekuita kwemibvunzo.

Mibvunzo pamusoro pematafura akapatsanurwa yakawana kuvandudzwa kunooneka, kunyanya kumatafura ane zviuru zvezvikamu zvinoda kushanda nezvikamu zvishoma chete zve data arrays. Kuita kwekuwedzera data kumatafura akapatsanurwa uchishandisa INSERT uye COPY yakagadziridzwa, pamwe nekukwanisa kubatanidza chikamu chitsva pasina kuvharira mibvunzo.

PostgreSQL 12 yaita imwe gadziriso kune indexing iyo inokanganisa kuita kwese, kusanganisira:

  • yakaderedzwa pamusoro paunenge uchigadzira WAL yeGiST, GIN uye SP-GiST index marudzi;
  • kugona kugadzira iyo inonzi inovhara indexes (INCLUDE clause) pane GiST indexes;
  • kugona kuita mibvunzo ye "muvakidzani wepedyo" (k-NN kutsvaga) uchishandisa chinhambwe opareta (<->) uye kushandisa SP-GiST indexes;
  • tsigiro yekuunganidza yakawanda-yakajairwa kukosha (MCV) nhamba uchishandisa CREATE STATISTICS, iyo inobatsira kuwana zvirinani zvirongwa zvemubvunzo kana uchishandisa makoramu ane hunhu hwakagoverwa zvisina kuenzana.

JIT kuunganidza uchishandisa LLVM, yakaunzwa muPostgreSQL 11, yave kugoneswa nekusarudzika. Kuunganidzwa kweJIT kunonatsiridza mashandiro kana uchishanda nemataurirwo muWHERE clauses, rondedzero yezvinangwa, aggregates, uye mamwe mashandiro emukati. Inowanikwa kana wakanyora PostgreSQL neLLVM kana uri kushandisa PostgreSQL package yakavakwa neLLVM yakagoneswa.

Kuvandudzwa kwemaitiro emutauro weSQL uye kuenderana kwakajairwa

PostgreSQL 12 yakaunza kugona kubvunza magwaro eJSON uchishandisa JSON nzira mataurirwo anotsanangurwa muSQL/JSON standard. Mivhunzo yakadai inogona kukwirisa nzira dziripo dzekunyoresa magwaro akachengetwa muJSONB fomati kuti itore data nemazvo.

Matauriro etafura akajairwa, anozivikanwawo seNE queries, anogona ikozvino kuurayiwa otomatiki achitsiva muPostgreSQL 12, iyo inogona kubatsira kuvandudza mashandiro emibvunzo yakawanda iripo. Mushanduro itsva, chikamu chinotsiva cheWITH query chinogona kungoitwa chete kana chisingadzokeri, chisina mhedzisiro, uye chinonongedzwa kamwe chete muchikamu chinotevera chemubvunzo.

PostgreSQL 12 inosuma rutsigiro rwe "makoramu anogadzirwa". Inotsanangurwa muchiyero cheSQL, rudzi rwekoramu iyi inoverenga kukosha zvichienderana nezviri mune mamwe makoramu mutafura imwechete. Mune iyi vhezheni, PostgreSQL inotsigira "akachengetwa akagadzirwa makoramu", uko kukosha kwakaverengerwa kunochengetwa pa diski.

Kudyidzana

PostgreSQL 12 inowedzera tsigiro yekubatanidzwa kweICU nekubvumira vashandisi kutsanangura "zvisinga-deterministic collations" izvo zvinogona, semuenzaniso, kubvumira kesi-isinganzwisisike kana accent-insensitive kuenzanisa.

Kusimbiswa

PostgreSQL inowedzera tsigiro yayo yenzira dzakasimba dzechokwadi ine akati wandei ekuwedzera anopa kumwe kuchengetedzeka uye kushanda. Kuburitswa uku kunosuma mutengi-parutivi uye sevha-parutivi encryption yekutendesa pamusoro peGSSAPI nzvimbo, pamwe nekugona kwePostgreSQL kuwana maseva eLDAP kana PostgreSQL yaunganidzwa neOpenLDAP.

Pamusoro pezvo, PostgreSQL 12 ikozvino inotsigira yakawanda-factor yekusimbisa sarudzo. Iyo PostgreSQL sevha inogona ikozvino kuda kuti mutengi ape chitupa cheSSL chakavimbika chine zita rekushandisa rinoenderana uchishandisa clientcert=verify-full, uye sanganisa izvi neyakasiyana nzira yechokwadi inodiwa (e.g. scram-sha-256).

Utongi

PostgreSQL 12 yakaunza kugona kuita isiri-kuvharira index kuvaka zvakare uchishandisa iyo REINDEX CONCURRENTLY kuraira. Izvi zvinobvumira vashandisi kuti vadzivise DBMS yekudzikira panguva yakareba index kuvaka.

Pamusoro pezvo, muPostgreSQL 12, unogona kugonesa kana kudzima macheki epeji muchikwata chekuvhara uchishandisa pg_checksums command. Pakutanga, mapeji ekutarisa, chinhu chinobatsira kuonesa kutendeseka kwedata rakachengetwa pa diski, yaigona chete kugoneswa kana iyo PostgreSQL cluster yakatangwa uchishandisa initdb.

Source: linux.org.ru

Voeg