Pa September 24, gulu lachitukuko linalengeza kutulutsidwa kwa nambala yotsatira ya Postgresql yotulutsidwa 13. Kutulutsidwa kwatsopano kunayang'ana, mwa zina, kupititsa patsogolo ntchito, kufulumizitsa ntchito zosamalira mkati ndi kuchepetsa kuyang'anira deta, komanso kuwongolera njira zodalirika zopezera.
Ntchito inapitilira pakukonza zolozera patebulo potengera kubwereza zomwe zalembedwa m'mitengo ya binary, zomwe zidapangitsa kuti zitheke kufulumizitsa kufunsa mafunso, komanso kuchepetsa danga la disk lomwe limakhala ndi index.
Kuphatikiza apo, algorithm yosinthira yowonjezereka yawonjezeredwa, momwe kusanja mobwerezabwereza zomwe zidasanjidwa kale m'magawo am'mbuyomu kumagwira ntchito mwachangu, ndipo mafunso ena amatha kufulumizitsidwa pogwiritsa ntchito ziwerengero zatsopano (kudzera pa lamulo la CREATE STATISTICS) powerengera sitepe yabwino kwambiri- ndondomeko ya pang'onopang'ono.
Kuyankha kwa mafunso ndi kusonkhanitsa deta yokwera mtengo kwakonzedwanso mwa kugwiritsa ntchito kwambiri kusonkhanitsa mwachangu ndikutaya gawo la data yophatikizidwa ku disk ngati sikukwanira mu RAM. Pali kuwonjezeka kwakukulu kwa liwiro la kulumikiza matebulo omwe ali pamagawo osiyanasiyana.
Ntchito yayikulu yachitika kuti kusamalitsa ndi kuyang'anira nkhokwe za Postgresql zikhale zosavuta. Ntchito yomanga ya "vacuuming", ndiko kuti, kugwiritsa ntchito danga laulere la disk mutachotsa kapena kulembanso mizere, tsopano ikhoza kuchitidwa mu ulusi wofanana, ndipo woyang'anira tsopano ali ndi mwayi wofotokozera nambala yawo. Kuphatikiza pa izi, zida zatsopano zawonjezedwa kuti ziwonetsere zomwe zikuchitika panobe ndi zolakwa zalephereka polumikizira zipika za mbiri yakale pakati pa master ndi replicas, zomwe zingayambitse mikangano pakuchotsa zofananira kapena kusokoneza kukhulupirika kwa zomwe zimagawidwa. Nawonso database atabwezeretsedwa kutengera zolemba za log.
Pakati pazatsopano za omanga, ndi bwino kuwunikira ntchito ya datetime (), yomwe imasintha mitundu yosiyanasiyana yojambulira nthawi kukhala mtundu wa Postgresql womangidwa; UUID generation ntchito v4 ikupezeka m'bokosi gen_random_uuid(); normalization ntchito ndi Unicode; dongosolo losinthika kwambiri logawira deta ya tebulo pamagulu olumikizana ndi ma netiweki a database ndi kubwereza kwathunthu pamlingo womveka, komanso kusintha kwina kwa mafunso ndi zoyambitsa zatsopano zomwe zilipo kwa replicas.
Nawonso achichepere kupeza ulamuliro wanenedwa monga mmodzi wa zigawo zikuluzikulu za dongosolo, ndipo Baibulo latsopano limapanga masitepe lalikulu pankhaniyi. Tsopano wogwiritsa ntchito mwayi yekha (superuser) akhoza kukhazikitsa zowonjezera ku database. Panthawi imodzimodziyo, ogwiritsa ntchito wamba adzatha kukhazikitsa zowonjezera zomwe adazilemba kuti ndizodalirika, kapena zowonjezera zowonjezera zomwe zimaonedwa kuti ndizodalirika (mwachitsanzo, pgcrypto, tablefunc kapena hstore). Mukatsimikizira ogwiritsa ntchito makina a SCRAM (pamene mukugwira ntchito kudzera pa driver wa libpq), "kumanga mayendedwe" tsopano pakufunika, ndipo ntchito yokulunga pa data ya chipani chachitatu postgres_fdw kuchokera ku mtundu 13 imathandizira kuvomereza satifiketi.
Source: linux.org.ru