Mgbe otu afọ mmepe gasịrị alaka ọhụrụ kwụsiri ike nke PostgreSQL 12 DBMS. Mmelite maka alaka ọhụrụ afọ ise ruo na Nọvemba 2024.
Main :
- agbakwunyere nkwado maka"", uru nke a na-agbakọ dabere na okwu na-ekpuchi ụkpụrụ nke ogidi ndị ọzọ na otu tebụl (yiri echiche, ma maka onye ogidi). Ogidi ndị emepụtara nwere ike ịbụ ụdị abụọ - echekwara na mebere. N'okwu nke mbụ, a na-agbakọ ọnụ ahịa n'oge agbakwunyere ma ọ bụ gbanwee data, na nke abụọ, a na-agbakọ ọnụ ahịa na nke ọ bụla na-agụ dabere na ọnọdụ ugbu a nke ogidi ndị ọzọ. Ugbu a, PostgreSQL na-akwado naanị kọlụm emepụtara echekwara;
- Agbakwunyere ike iji jụọ data sitere na dọkụmentị JSON , na-echetara ya ma kọwaa na ọkọlọtọ SQL/JSON. A na-eji usoro indexing dị ugbu a iji melite arụmọrụ nke nhazi okwu ndị dị otú ahụ maka akwụkwọ echekwara na usoro JSONB;
- Akwanyere site na ndabara bụ iji ihe nchịkọta JIT (Naanị-na-oge) dabere na mmepe LLVM iji mee ka mmezu nke ụfọdụ okwu dị ngwa n'oge nhazi ajụjụ SQL. Dịka ọmụmaatụ, a na-eji JIT mee ka mmejuputa okwu dị ngwa ngwa n'ime WHERE blocks, ndepụta ebumnuche, okwu mkpokọta, na ụfọdụ ọrụ ime;
- Emeela ka arụmọrụ ndenye aha ka mma. A na-ahazi ndenye aha osisi B ka ọ rụọ ọrụ na gburugburu ebe ndenye aha na-agbanwe ugboro ugboro - Nnwale TPC-C na-egosi mmụba n'ozuzu ya na arụmọrụ yana nkezi mbelata na oriri ohere diski nke 40%. Mbelata n'elu mgbe ị na-emepụta log-n'ihu log (WAL) maka ụdị ndeksi GiST, GIN na SP-GiST. Maka GiST, agbakwunyela ikike imepụta ndepụta ihe mkpuchi (site na okwu INCLLUDE) nke gụnyere kọlụm ndị ọzọ. Na arụ ọrụ Na-enye nkwado maka ọnụ ọgụgụ Kachasị Bara Uru (MCV) iji wepụta atụmatụ ajụjụ kachasị mma mgbe ị na-eji ogidi ndị ekesaghị oke;
- A na-ahazi mmejuputa nkewa nkewa maka ajụjụ ndị gafere tebụl nwere ọtụtụ puku nkebi, mana enwere oke na ịhọrọ oke data. Arụmọrụ nke ịgbakwunye data na tebụl ndị kewara ekewa site na iji INSERT na arụ ọrụ COPY abawanyela, ọ nwekwara ike ịgbakwunye ngalaba ọhụrụ site na "ALTER TABLE ATTACH PARTITION" na-egbochighị mmezu ajụjụ;
- Nkwado agbakwunyere maka mgbasawanye ahịrị ahịrị akpaka nke okwu tebụl achịkọtara (, CTE) nke na-enye ohere iji akara nsonaazụ aha nwa oge akọwapụtara site na iji nkwupụta WITH. Nbunye ntanetị nwere ike imeziwanye arụmọrụ nke ọtụtụ ajụjụ, mana a na-eji ya naanị maka CTE ndị na-abụghị ndị na-emegharị emegharị;
- nkwado agbakwunyere Njirimara nke mpaghara "Collation", nke na-enye gị ohere ịtọ usoro nhazi na ụzọ dabara na-echebara ihe odide pụtara (dịka ọmụmaatụ, mgbe ị na-edozi ụkpụrụ dijitalụ, ọnụnọ nke mwepu na ntụpọ n'ihu ọnụ ọgụgụ na ụdị dị iche iche. A na-eburu n'uche nke mkpoputa, na mgbe a na-atụnyere ya, a naghị echebara ihe odide na ọnụnọ nke akara ụda anya);
- Nkwado agbakwunyere maka nyocha ndị ahịa ọtụtụ ihe, nke na pg_hba.conf ị nwere ike ijikọ nzere SSL (clientcert=verify-full) yana usoro nyocha ọzọ dị ka scram-sha-256 maka nyocha;
- Nkwado agbakwunyere maka izo ya ezo nke ọwa nkwukọrịta mgbe ị na-achọpụta site na , ma n'akụkụ ndị ahịa na n'akụkụ ihe nkesa;
- Nkwado agbakwunyere maka ịchọpụta sava LDAP dabere na ndekọ “DNS SRV” ma ọ bụrụ na ejiri OpenLDAP rụọ PostgreSQL;
- agbakwunyere ọrụ"» iji wughachi index na-enweghị igbochi ọrụ dee na index;
- agbakwunyere iwu , nke na-enye gị ohere ịme ma ọ bụ gbanyụọ nlele nlele ibe data maka nchekwa data dị (na mbụ akwadoro ọrụ a naanị n'oge mmalite nchekwa data);
- Enyere mmepụta nke egosi ọganihu maka arụmọrụ CREATE INDEX, REINDEX, CLUSTER, VACUUM FULL na pg_checksums;
- agbakwunyere iwu"» ijikọ ndị na-ahụ maka usoro nchekwa tebụl ọhụrụ emebere maka ọrụ dị iche iche akọwapụtara. Ugbu a naanị usoro ịnweta tebụl etinyere bụ "obo";
- Ejikọtala faịlụ nhazi recovery.conf na postgresql.conf. Dị ka ihe na-egosi mgbanwe na ọnọdụ mgbake mgbe ọdịda gasịrị, ugbu a jiri faịlụ recovery.signal na standby.signal.
isi: opennet.ru