Date: Thu, 28 Mar 2024 17:20:01 +0100 (CET) Message-ID: <177854679.111160.1711642801818@srvdoc.doc.ipesoft.com> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_111159_422087661.1711642801818" ------=_Part_111159_422087661.1711642801818 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
Kompresia d=C3=A1t trezora trezora je implementovan=C3=A1 na pla= tforme PostgreSQL. Vykon=C3=A1va optimaliz=C3=A1ciu jeho =C5=A1trukt=C3=BAr= y a nieko=C4=BEkokr=C3=A1t zmen=C5=A1=C3=AD jeho ve=C4=BEkos=C5=A5. Do komp= rimovan=C3=A9ho trezora u=C5=BE nie je mo=C5=BEn=C3=A9 zapisova=C5=A5 (ani = utilitou arcsynchro). Kompresia d=C3=A1t je dostupn=C3=A1 v D2000 verz= ii 21 a vy=C5=A1=C5=A1ej. Nastavenie parametra TrezorCompress =3D 1 z= ap=C3=ADna kompresiu d=C3=A1t trezora po jeho odpojen=C3=AD.
Aj star=C5=A1ie trezory je mo=C5=BEn=C3=A9 skomprimova=C5=A5 =E2=80=9Eru= =C4=8Dne=E2=80=9D pomocou tell pr=C3=ADkazu TREZOR COMPRESS. = Je podporen=C3=BD aj opa=C4=8Dn=C3=BD proces =E2=80=93 dekompresia pomocou = tell pr=C3=ADkazu TREZOR DECOMPRESS.
R=C3=BDchlos=C5=A5 =C4=8D=C3=ADtania z komprimovan=C3=BDch trezorov je p= orovnate=C4=BEn=C3=A1 s nekomprimovan=C3=BDmi. V niektor=C3=BDch = hrani=C4=8Dn=C3=BDch pr=C3=ADpadoch (=C4=8D=C3=ADtanie konkr=C3=A9tnej hodn= oty v =C4=8Dase) m=C3=B4=C5=BEu by=C5=A5 komprimovan=C3=A9 trezory pom= al=C5=A1ie. V in=C3=BDch pr=C3=ADpadoch m=C3=B4=C5=BEe by=C5=A5 =C4=8D=C3= =ADtanie komprimovan=C3=BDch d=C3=A1t r=C3=BDchlej=C5=A1ie (z=C3=A1le=C5=BE= =C3=AD od pomeru r=C3=BDchlosti a z=C3=A1=C5=A5a=C5=BEe I/O subsyst=C3=A9mu= a procesora). Navy=C5=A1e kompresia d=C3=A1t umo=C5=BEn=C3=AD uchov=C3=A1v= anie v=C3=A4=C4=8D=C5=A1ieho mno=C5=BEstva d=C3=A1t v pam=C3=A4ti (v cache = opera=C4=8Dn=C3=A9ho syst=C3=A9mu a PostgreSQL).
Pr=C3=A1cu s komprimovan=C3=BDmi trezormi je mo=C5=BEn=C3=A9 si vys= k=C3=BA=C5=A1a=C5=A5 =E2=80=9Ena ne=C4=8Disto=E2=80=9C. Nastavenie parametr= a TrezorC= ompressKeep =3D 1 sp=C3=B4sob=C3=AD, =C5=BEe pri kompresii vzn= ikn=C3=BA tabu=C4=BEky s komprimovan=C3=BDmi d=C3=A1tami (CDATA, DATA0= ), ale p=C3=B4vodn=C3=A1 tabu=C4=BEka (DATA) sa nevyma=C5=BEe. Po kompresii= sa n=C3=A1sledne =C4=8D=C3=ADtaj=C3=BA komprimovan=C3=A9 d=C3=A1ta. Pr=C3= =ADkazom TREZOR DECOMPRESS. je mo=C5=BEn=C3=A9 sa ve= =C4=BEmi r=C3=BDchlo vr=C3=A1ti=C5=A5 k p=C3=B4vodnej =C5=A1trukt=C3= =BAre trezora, ke=C4=8F=C5=BEe nie je nutn=C3=A9 vykona=C5=A5 dekompresiu, = ale sta=C4=8D=C3=AD vymaza=C5=A5 tabu=C4=BEky s komprimovan=C3=BDmi d= =C3=A1tami.
Praktick=C3=A9 testy uk=C3=A1zali, =C5=BEe kompresia d=C3=A1t v tre= zore prebieha r=C3=BDchlej=C5=A1ie, ak s=C3=BA predt=C3=BDm d=C3=A1ta uprat= an=C3=A9. Preto existuje parameter TrezorCompressReorg, ktor=C3=BD je = prednastaven=C3=BD na hodnotu 1 a ktor=C3=BD aktivuje reorganiz=C3=A1c= iu d=C3=A1ta pred kompresiou.
V=C3=BDpis trezorov pr=C3=ADkazom LIST_TREZOR ukazuje pr= i komprimovan=C3=BDch trezoroch pr=C3=ADznak cps:
Received TELL command : LIST_TREZOR
List all
List of exist= ing trezors:
-----------------------------------------------------------= ---------------
ID | Data start(UTC)| Data end(UTC) | &= nbsp; Status &nb= sp; = |
---------------------------------------------------------------= -----------
0134 31-05-2020 22:00 30-06-2020 22:00 being used for writin= g
0133 30-04-2020 22:00 31-05-2020 22:00 mounted read-only cps
= 0132 31-03-2020 22:00 30-04-2020 22:00 mounted read-only cps
0131 = 29-02-2020 23:00 31-03-2020 22:00 mounted read-only
0130 31-01-202= 0 23:00 29-02-2020 23:00 mounted read-only
Komprimovan=C3=A9 trezory na PostgreSQL podliehaj=C3=BA nasledovn=C3=A9m= u obmedzeniu: ve=C4=BEkos=C5=A5 d=C3=A1t jedn=C3=A9ho arch=C3=ADvneho objek= tu (resp. jednej polo=C5=BEky =C5=A1trukt=C3=BArovan=C3=A9ho arch=C3=ADvu),= ktor=C3=A9 sa ukladaj=C3=BA do jedn=C3=A9ho riadku komprimovanej d=C3=A1to= vej tabu=C4=BEky CDATA, mus=C3=AD by=C5=A5 men=C5=A1ia ako 1 GB. V opa=C4= =8Dnom pr=C3=ADpade kompresia skon=C4=8D=C3=AD s chybou a je vyp=C3=ADsan= =C3=A9 ID objektu, ktor=C3=BD ju sp=C3=B4sobil. Pr=C3=ADklad:
[2021-04-05 20:36:52.371]E MES_TREZOR_20 ExecSqlCommand insert into cd= ata with avgc as (select '20090701 000000.000'::timestamp as cmin, '2009080= 1 000000.000'::timestamp as cmax,'20090701 000000.000'::timestamp + ('20090= 801 000000.000'::timestamp - '20090701 000000.000'::timestamp)/2 as c), sda= ta as (SELECT * from data where "ID"=3D 1309454 and "ROW"=3D 0 and "COL"=3D= 0 order by "CAS") select "ID", "ROW", "COL", avgc.c, array_agg( ((extract = (epoch from "CAS"-avgc.c)*1000)::integer, "VALUE", "STATUS", "LIMIT_STATUS"= , "ARCHIV_STATUS", "FLAGS")::d2trzitem) from sdata, avgc where "CAS" betwee= n avgc.cmin and avgc.cmax + '1 hour'::interval group by "ID", "ROW", "COL",= avgc.c
(54000)ERROR: array size exceeds the maximum allowed (1073741823= );
[2021-04-05 20:36:52.381]E Error inserting cdata for 20 ID=3D$130= 9454
TrezorCompress - zapnutie kompresie d=C3=A1t trezora. Kom=
presia d=C3=A1ta prebehne pri odp=C3=A1jan=C3=AD trezora.
Paramete=
r m=C3=B4=C5=BEe by=C5=A5 zmenen=C3=BD za behu tell pr=C3=ADkazom S=
ET_OPTION TrezorCompress.
Ak chcete vymaza=C5=A5 kompr= imovan=C3=A9 d=C3=A1ta a zachova=C5=A5 nekomprimovan=C3=A9, pou=C5= =BEite nasledovn=C3=BD postup:
- =
Pr=C3=ADkazom SET_OPTION TREZOR_COMPRESS_KEEP OFF
- = Pr=C3=ADkazom TREZOR DECOMPRESS&nbs= p;vykonajte dekompresiu d=C3=A1t trezora (dekompresia prebehne r=C3=BDchlo,= ke=C4=8F=C5=BEe bud=C3=BA iba vymazan=C3=A9 tabu=C4=BEky s komprimova= n=C3=BDmi d=C3=A1tami - CDATA, DATA0).
Ak chcete zachova=C5=A5 komprimova= n=C3=A9 d=C3=A1ta a vymaza=C5=A5 nekomprimovan=C3=A9, pou=C5=BEite= nasledovn=C3=BD postup:
- Pr=C3=ADkazom TR= EZOR DECOMPRESS vykonajte dekompresiu d=C3=A1t trezora (dekompresi= a prebehne r=C3=BDchlo, ke=C4=8F=C5=BEe bude iba trezor ozna=C4=8Den=C3=BD = ako dekomprimovan=C3=BD. V=C4=8Faka hodnote parametra TrezorCompres= sKeep=3D1 nebud=C3=BA vymazan=C3=A9 tabu=C4=BEky s komprimova= n=C3=BDmi d=C3=A1tami - CDATA, DATA0).
- Pr=C3=ADkazom SET_OPTION TREZOR_COMPRESS_KEEP OFF nastavte= hodnotu parametra TrezorCompressKeep na 0.
- Pr=C3=ADkazom TREZ=
OR COMPRESS vykonajte kompresiu d=C3=A1t trezora (kompresia prebeh=
ne r=C3=BDchlo, ke=C4=8F=C5=BEe sa pou=C5=BEij=C3=BA existuj=C3=BAce d=C3=
=A1ta v tabu=C4=BEk=C3=A1ch s komprimovan=C3=BDmi d=C3=A1tami). Kompresia v=
yma=C5=BEe tabu=C4=BEku s p=C3=B4vodn=C3=BDmi nekomprimovan=C3=BDmi d=
=C3=A1tami (DATA).
TrezorCompressReorg - reorganiz=C3=A1cia d=C3=
=A1t trezora pred kompresiou. Tento parameter m=C3=A1 prednastaven=C3=BA ho=
dnotu 1 - v praxi sa ukazuje, =C5=BEe je efekt=C3=ADvnej=C5=A1ie a r=C3=BDc=
hlej=C5=A1ie najsk=C3=B4r zreorganizova=C5=A5 d=C3=A1ta (SQL pr=C3=ADkazom =
CLUSTER DATA) a a=C5=BE n=C3=A1sledne vykona=C5=A5 ich kompresiu. =
Hodnota 0 vyp=C3=ADna reorganiz=C3=A1ciu d=C3=A1t trezora pred kompres=
iou. Vypnutie reorganiz=C3=A1cie pred kompresiou nie je odpor=C3=BA=C4=
=8Dan=C3=A9.
Parameter m=C3=B4=C5=BEe by=C5=A5 zmenen=C3=BD za beh=
u tell pr=C3=ADkazom SET_OPTION TrezorCompressReorg.
TrezorCompressOrd=
er - parameter sa t=C3=BDka =C4=8D=C3=ADtania z trezorov s ko=
mprimovan=C3=BDmi d=C3=A1tami. Tento parameter ud=C3=A1va, =C4=8Di pri =C4=
=8D=C3=ADtan=C3=AD d=C3=A1t z komprimovan=C3=A9ho trezora je nutn=C3=
=A9 pou=C5=BEi=C5=A5 zoradenie pod=C4=BEa =C4=8Dasu. Ke=C4=8F=C5=BEe s=C3=
=BA d=C3=A1ta zoraden=C3=A9 pri kompresii, =C5=A1tandardne je mo=C5=BEn=C3=
=A9 necha=C5=A5 parameter na hodnote 0, =C4=8Do zr=C3=BDch=C4=BEuje =C4=8D=
=C3=ADtanie z komprimovan=C3=A9ho trezora (vynech=C3=A1va sa ORDER BY)=
.
Parameter m=C3=B4=C5=BEe by=C5=A5 zmenen=C3=BD za behu tell pr=
=C3=ADkazom SET_OPTION TrezorCompressOrder.
=
p>