História stránky

...

[2021-04-05 20:36:52.371]E MES_TREZOR_20 ExecSqlCommand insert into cdata with avgc as (select '20090701 000000.000'::timestamp as cmin, '20090801 000000.000'::timestamp as cmax,'20090701 000000.000'::timestamp + ('20090801 000000.000'::timestamp - '20090701 000000.000'::timestamp)/2 as c), sdata as (SELECT * from data where "ID"= 1309454 and "ROW"= 0 and "COL"= 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" between 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=$1309454

Kotva
parametre_pre_pgsql parametre_pre_pgsql

...

Configuration parameters of depository data compression for the PostgreSQL platform:

• Kotva
  trezorcompress trezorcompress

  TrezorCompress - parameter activates depository data compression. Data is compressed when the depository is disconnected.
  The parameter can be changed online, by the SET_OPTION TrezorCompress command.
  
  

• Kotva
  trezorcompresskeep trezorcompresskeep

  TrezorCompressKeep - parameter is used to test depository data compression. If set to 1, the original data table (DATA) will not be deleted but will be retained. However, the data will be read from tables with compressed data (CDATA, DATA0). The TREZOR DECOMPRESS command can be used to return very quickly to the original structure of the vault, as it is not necessary to perform decompression, but simply delete the tables with compressed data.
  The parameter can be changed online, by the SET_OPTION TrezorCompressKeep command.

To delete the compressed data and to keep the original uncompressed data, follow these steps:

...