Ivai neChishanu chakanaka mose! Nguva shoma uye shoma yasara kosi isati yatanga , saka nhasi tiri kugovera kushandurwa kwechimwe chinhu chinobatsira pamusoro pehurukuro.
Padanho rebudiriro Pave paine rimwe basa rinonakidza rakaitwa kuvandudza tafura yekugovera. Partitioning matafura -Iri ibasa raivepo muPostgreSQL kwenguva yakareba, asi iro, sekutaura, rakange risipo kusvika vhezheni yegumi, iyo yakava basa rinobatsira. Isu takambotaura kuti nhaka yetafura ndiko kuita kwedu kugovera, uye ichi ichokwadi. Iyi nzira chete ndiyo yakakumanikidza kuita rakawanda rebasa nemaoko. Semuenzaniso, kana iwe waida kuti tuples iiswe muzvikamu panguva yeINSERTs, waizofanira kugadzirisa zvinokonzeresa kuti zvikuitire izvi. Kupatsanura kuburikidza nenhaka kwaive kunonoka uye kwakaoma kukudziridza mamwe maitiro pamusoro pe.
MuPostgreSQL 10, takaona kuzvarwa kwe "declarative partitioning," chinhu chakagadzirirwa kugadzirisa matambudziko mazhinji akange asingagadzirike uchishandisa nzira yekare yenhaka. Izvi zvakatungamira kune chishandiso chine simba zvakanyanya icho chakatibvumira kupatsanura data zvakachinjika!
Kuenzanisa kwechimiro
PostgreSQL 11 inosvitsa inonakidza seti yezvinhu zvitsva zvinobatsira kuvandudza mashandiro uye kuita kuti matafura akapatsanurwa ave pachena kune maapplication.
1. Kushandisa Limiting Exceptions
2. Anowedzera nodes chete
3. Chetetafura yakakamurwa inonongedza isina kupatsanurwa
4. Ma indexes anofanira kunge aine makoramu ese akakosha echikamu
5. Zvirambidzo zvechikamu kumativi ese maviri zvinofanirwa kuenderana
Kubudirira
Tinewo mashoko akanaka pano! Nzira itsva yakawedzerwa . Iyi itsva algorithm inogona kuona zvikamu zvakakodzera nekutarisa mamiriro emubvunzo WHERE. Iyo yapfuura algorithm, zvakare, yakaongorora chikamu chimwe nechimwe kuti chione kana chaigona kusangana nemamiriro acho WHERE. Izvi zvakaguma nekuwedzera kwekuwedzera munguva yekuronga sezvo nhamba yezvikamu yakawedzera.
Muna 9.6, nekugovanisa kuburikidza nenhaka, kuendesa tuples muzvikamu kwaiwanzoitwa nekunyora trigger basa raive nenhevedzano yezvirevo zveIF kuisa tuple muchikamu chaicho. Aya mabasa anogona kunonoka kuita. Nekuzivisa kwekuparadzanisa kwakawedzerwa muvhezheni 10, izvi zvinoshanda nekukurumidza.
Tichishandisa tafura yakakamurwa ine zvikamu zana, tinogona kuongorora mashandiro ekurodha miriyoni gumi mitsetse mutafura ine 100 BIGINT column uye 10 INT column.
Kuita kwekubvunza tafura iyi kuti uwane rekodhi imwe yakarongedzerwa uye kuita DML kushandura rekodhi rimwe chete (uchishandisa 1 chete processor):
Pano tinogona kuona kuti kushanda kwega kwega kwakawedzera zvakanyanya kubva paPG 9.6. Zvikumbiro SELECT tarisa zvirinani, kunyanya izvo zvinokwanisa kusasanganisa zvikamu zvakawanda panguva yekuronga mibvunzo. Izvi zvinoreva kuti mugadziri anogona kusvetuka basa rakawanda raaifanira kunge akaita kare. Semuenzaniso, nzira hadzichagadzirirwe zvikamu zvisingakoshi.
mhedziso
Kupatsanura tafura kuri kutanga kuve chinhu chine simba kwazvo muPostgreSQL. Iyo inokutendera iwe kukurumidza kuratidza data pamhepo uye kuitora kunze kwenyika pasina kumirira kunonoka, kukuru kweDML mashandiro kuti apedze.. Izvi zvinoreva zvakare kuti data rakabatana rinogona kuchengetwa pamwechete, zvichireva kuti data raunoda rinogona kuwanikwa zvakanyanya. Magadzirirwo akaitwa muvhezheni iyi angadai asina kuitika pasina vanogadzira, vanoongorora uye vanozvipira vakashanda vasinganeti pazvinhu izvi zvese.
Ndinotenda kwavari vese! PostgreSQL 11 inotaridzika zvakanaka!
Heino chinyorwa chipfupi chakadaro asi chinonakidza. Govera zvaunofunga uye usakanganwa kusaina , mukati umo chirongwa chekosi chichatsanangurwa zvakadzama.
Source: www.habr.com