ProHoster > Blog > internet nhau > PostgreSQL 12 DBMS kuburitswa

PostgreSQL 12 DBMS kuburitswa

Mushure megore rebudiriro rakabudiswa bazi idzva rakatsiga rePostgreSQL 12 DBMS. Zvigadziriso zvebazi idzva achabuda kwemakore mashanu kusvika munaNovember 2024.

chikuru zvitsva:

  • Yakawedzerwa rutsigiro rwe "yakagadzirwa columns", kukosha kweiyo inoverengerwa zvichienderana neshoko rinofukidza kukosha kwemamwe makoramu mutafura imwechete (yakafanana nekuona, asi kune yega makoramu). Makoramu anogadzirwa anogona kuve emhando mbiri - dzakachengetwa uye dzechokwadi. Muchiitiko chekutanga, kukosha kunotarwa panguva iyo data yakawedzerwa kana kuchinjwa, uye muchiitiko chechipiri, kukosha kunotarirwa pane imwe neimwe kuverenga zvichienderana nemamiriro ezvinhu ezvino mamwe makoramu. Parizvino, PostgreSQL inotsigira chete makoramu akachengetwa akachengetwa;
  • Yakawedzera kugona kubvunza data kubva kuJSON zvinyorwa uchishandisa Nzira dzekutaura, chiyeuchidzo XPath uye inotsanangurwa muSQL/JSON standard. Nzira dzekunyora dziripo dzinoshandiswa kuvandudza kushanda kwekugadzirisa mazwi akadaro kune zvinyorwa zvakachengetwa muJSONB format;
  • Inogoneswa nekusarudzika iko kushandiswa kweJIT (Just-in-Time) compiler yakavakirwa pakuvandudzwa kweLLVM kuti ikurumidze kuita mamwe mataurirwo panguva yeSQL query processing. Semuyenzaniso, JIT inoshandiswa kukurumidzira kuitwa kwekutaura mukati mekuti WHERE mabhuroko, rondedzero yezvinangwa, aggregate mataurirwo, uye kumwe kushanda kwemukati;
  • Indexing performance yakavandudzwa zvakanyanya. B-miti indexes inogadziridzwa kushanda munzvimbo umo indexes inoshanduka kakawanda - TPC-C bvunzo inoratidza kuwedzera kwese kwekuita uye kuderedzwa kwepakati kwedhisiki nzvimbo yekushandisa ye40%. Yakaderedzwa pamusoro paunenge uchigadzira kunyora-mberi log (WAL) yeGiST, GIN uye SP-GiST index marudzi. Kune GiST, kugona kugadzira wrapper indexes (kuburikidza neiyo INCLUDE kutaura) iyo inosanganisira mamwe makoramu akawedzerwa. Mukushanda Gadzira STATISTICS Inopa tsigiro yeYakanyanya Kukosha Kukosha (MCV) nhamba kuti igadzire yakanyatso gadziriso yezvirongwa kana uchishandisa makoramu akagoverwa zvisina kuenzana;
  • Kuitwa kwekukamura kwakagadziridzwa kumibvunzo inotenderera matafura ane zviuru zvezvikamu, asi inogumira pakusarudza shoma shoma yedata. Kuita kwekuwedzera data kumatafura akapatsanurwa uchishandisa INSERT uye COPY mashandiro akawedzerwa, uye zvakare zvinokwanisika kuwedzera zvikamu zvitsva kuburikidza ne "ALTER TABLE ATTACH PARTITION" pasina kuvharira query execution;
  • Yakawedzera tsigiro ye otomatiki inline yekuwedzera ye generalized tafura mataurirwo (Common Table Expression, CTE) inobvumira kushandiswa kwemaseti enguva pfupi ane mazita anotsanangurwa uchishandisa WITH chirevo. Inline deployment inogona kuvandudza kushanda kwemibvunzo yakawanda, asi ikozvino inoshandiswa chete kune isingadzokeri CTEs;
  • Yakawedzerwa rutsigiro non-deterministic zvimiro zvenzvimbo ye "Collation", iyo inokutendera iwe kuti uise mitemo yekuronga uye nzira dzekufananidza uchifunga zvinorehwa nevatambi (semuenzaniso, paunenge uchironga dhijitari, kuvapo kweminus uye doti pamberi penhamba nemhando dzakasiyana. zvezviperengo zvinotariswa, uye kana tichienzanisa, nyaya yevatambi uye kuvapo kwechiratidzo chekutaura hazvifungidzirwe);
  • Yakawedzera tsigiro yeakawanda-factor mutengi kutendeseka, umo mu pg_hba.conf unogona kusanganisa SSL chitupa chechokwadi (clientcert=verify-full) neimwe nzira yekuwedzera yekusimbisa se scram-sha-256 yekusimbisa;
  • Yakawedzera rutsigiro rwe encryption yenzira yekutaurirana kana uchisimbisa kuburikidza GSSAPI, zvese kudivi remutengi uye kudivi reseva;
  • Yakawedzerwa rutsigiro rwekuona maseva eLDAP akavakirwa pa "DNS SRV" marekodhi kana PostgreSQL yakavakwa neOpenLDAP;
  • Yakawedzerwa operation "REINDEX CONCURRENTLYΒ»kuvakazve indexes pasina kuvharidzira kunyora mashandiro kune index;
  • Added command pg_checks, iyo inokutendera iwe kugonesa kana kudzima cheki cheki yemapeji edata kune iripo dhatabhesi (kare kushanda uku kwaitsigirwa chete panguva yekutanga dhatabhesi);
  • Yakapihwa kubuda kwechiratidzo chekufambira mberi kwekushanda GADZIRA INDEX, REINDEX, CLUSTER, VACUUM FULL uye pg_checksums;
  • Added command "GADZIRA NZIRA YEKUSVIKAΒ» kubatanidza vanobata nzira nyowani dzekuchengetedza tafura dzakagadziridzwa kune akasiyana chaiwo mabasa. Parizvino iyo chete yakavakirwa-mukati tafura yekuwana nzira ndeye "murwi";
  • Iyo recovery.conf configuration file yabatanidzwa ne postgresql.conf. Sezviratidzi zvekuchinja kune mamiriro ekugadzirisa mushure mekukundikana, ikozvino ndinofanira shandisa recovery.signal uye standby.signal mafaira.

Source: opennet.ru

Voeg