Ndị otu PostgreSQL ekwupụtala mwepụta nke PostgreSQL 12, ụdị kachasị ọhụrụ nke sistemụ njikwa nchekwa data mepere emepe.
PostgreSQL 12 emeela ka arụmọrụ ajụjụ dịkwuo mma - karịsịa mgbe ị na-arụ ọrụ na nnukwu data, ma kwalitekwa iji ohere diski n'ozuzu ya.
Atụmatụ ọhụrụ gụnyere:
- mmejuputa asụsụ ajụjụ ụzọ JSON (akụkụ kachasị mkpa nke ọkọlọtọ SQL/JSON);
- njikarịcha ogbugbu nke okwu tebụl nkịtị (WITH);
- nkwado maka ogidi ndị emepụtara
Ndị obodo na-aga n'ihu na-arụ ọrụ na extensibility na ntụkwasị obi nke PostgreSQL, na-emepe nkwado maka mba ụwa, ikike nyocha, na ịnye ụzọ dị mfe iji nye usoro ahụ.
Ntọhapụ a na-agụnye ntinye nke interface maka ngwa nchekwa pluggable, nke na-enye ndị mmepe ohere ịmepụta ụzọ nchekwa data nke ha.
Ndozi arụmọrụ
PostgreSQL 12 gụnyere arụmọrụ dị ịrịba ama na mmezi mmezi maka nhazi usoro na nkewa.
Ndekọ osisi B-osisi, ụdị ọkọlọtọ ọkọlọtọ dị na PostgreSQL, ka emezigoro na ụdị 12 maka ibu ọrụ na-agụnye mgbanwe ndenye aha ugboro ugboro. Iji akara nrịbama TPC-C maka PostgreSQL 12 gosipụtara nkezi 40% na ojiji oghere yana mmụba n'ozuzu ya na arụmọrụ ajụjụ.
Ajụjụ megide tebụl ndị kewara ekewa enwetala nkwalite ndị pụtara ìhè, ọkachasị maka tebụl nwere ọtụtụ puku akụkụ nke chọrọ iji naanị akụkụ pere mpe nke data arrays rụọ ọrụ. Arụ ọrụ nke ịgbakwunye data na tebụl kewara ekewa site na iji INSERT na COPY, yana ike itinye akụkụ ọhụrụ na-enweghị igbochi ajụjụ.
PostgreSQL 12 emela nkwalite ndị ọzọ na ntinye aha na-emetụta arụmọrụ niile, gụnyere:
- mbelata n'elu mgbe ị na-emepụta WAL maka ụdị ndeksi GiST, GIN na SP-GiST;
- ike ịmepụta ihe a na-akpọ mkpuchi mkpuchi (INCLUDE clause) na ndeksi GiST;
- ikike ịme ajụjụ "onye agbata obi kacha nso" (nchọ k-NN) site na iji onye ọrụ anya (<->) na iji SP-GiST index;
- nkwado maka ịnakọta ọnụ ọgụgụ a na-ahụkarị (MCV) site na iji CREATE STATISTICS, nke na-enyere aka nweta atụmatụ ajụjụ ka mma mgbe ị na-eji ogidi ndị a na-ekesa ụkpụrụ ya na-ezighi ezi.
Nchikota JIT site na iji LLVM, ewebata na PostgreSQL 11, na-enyere ya aka ugbu a site na ndabara. Nchịkọta JIT na-eme ka arụmọrụ dịkwuo mma mgbe ọ na-arụ ọrụ na nkwupụta na WHERE nkebiokwu, ndepụta ebumnuche, nchịkọta, na ụfọdụ ọrụ ime. Ọ dị ma ọ bụrụ na i jiri LLVM chịkọta PostgreSQL ma ọ bụ na-eji ngwugwu PostgreSQL nke ejiri LLVM rụọ ọrụ.
Mmelite na ike asụsụ SQL yana ndakọrịta ọkọlọtọ
PostgreSQL 12 webatara ikike ịjụ akwụkwọ JSON site na iji okwu ụzọ JSON akọwapụtara na ọkọlọtọ SQL/JSON. Ajụjụ ndị dị otú ahụ nwere ike itinye usoro ntinye aha dị adị maka akwụkwọ echekwara n'ụdị JSONB iji weghachite data nke ọma.
Okwu tebụl ndị a na-ahụkarị, nke a makwaara dị ka WITH ajụjụ, nwere ike igbuzi ozugbo site na iji nnọchi na PostgreSQL 12, nke n'aka nke ya nwere ike inye aka melite arụmọrụ nke ọtụtụ ajụjụ dị adị. N'ụdị ọhụrụ a, akụkụ ngbanwe nke ajụjụ WITH nwere ike ịme ma ọ bụrụ na ọ bụghị nke na-emegharịghachi, enweghị mmetụta ọ bụla, ma atụnyere ya naanị otu ugboro na mpaghara na-esote nke ajụjụ ahụ.
PostgreSQL 12 na-ewebata nkwado maka "ogidi ndị emepụtara". Akọwara na ọkọlọtọ SQL, ụdị kọlụm a na-agbakọ uru dabere na ọdịnaya nke kọlụm ndị ọzọ na otu tebụl. Na ụdị a, PostgreSQL na-akwado "ogidi ndị echekwabara", ebe a na-echekwa uru gbakọọ na diski.
Mmekọrịta Mmekọrịta
PostgreSQL 12 na-agbasa nkwado maka mkpokọta ICU site n'ikwe ka ndị ọrụ kọwaa "mkpokọta ndị na-abụghị deterministic" nke nwere ike, dịka ọmụmaatụ, nye ohere ntụnyere okwu na-enweghị mmetụta ma ọ bụ ụda-enweghị mmetụta.
Nyocha
PostgreSQL na-agbasa nkwado ya maka ụzọ nyocha siri ike yana ọtụtụ nkwalite na-enye nchekwa na ọrụ ndị ọzọ. Ntọhapụ a na-ewebata akụkụ ndị ahịa na ihe nkesa-nzuzo maka nyocha n'elu oghere GSSAPI, yana ike maka PostgreSQL ịchọpụta sava LDAP mgbe ejiri OpenLDAP chịkọta PostgreSQL.
Na mgbakwunye, PostgreSQL 12 na-akwado nhọrọ nyocha ọtụtụ ihe. Ihe nkesa PostgreSQL nwere ike chọọ ugbu a onye ahịa ka o nye asambodo SSL dị irè yana aha njirimara kwekọrọ na iji clientcert=verify-full, ma jikọta nke a na usoro nyocha dị iche (dịka scram-sha-256).
Nchịkwa
PostgreSQL 12 webatara ikike iji iwu REINDEX CONCURRENTLY rụọ nrụpụta ndetu anaghị egbochi. Nke a na-enye ndị ọrụ ohere ịzenarị DBMS downtime n'oge ogologo index wughachi.
Na mgbakwunye, na PostgreSQL 12, ị nwere ike mee ma ọ bụ gbanyụọ ndenye akwụkwọ n'ime ụyọkọ mmechi site na iji iwu pg_checksums. Na mbụ, checksums ibe, njirimara na-enyere aka nyochaa iguzosi ike n'ezi ihe nke data echekwara na diski, enwere ike ịgbanye naanị mgbe ewepụtara ụyọkọ PostgreSQL site na iji initdb.
isi: linux.org.ru